XF 2.3 How to find thread prefixes?

[Robert9]

How to find thread prefixes?​

I need to search for prefixes, but not with a given list;
i need to search for "Paris" to get the prefix_id.

Maybe someone has a tipp for me where to find a function for it?
I guess i have to search the phrases.

 

[Robert9]

SELECT * FROM xf_phrase WHERE phrase_text LIKE 'Paris'