Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at

RSS Latest posts from my personal blog

Most viewed posts

Subscribe to RSS feed

Searching for a WPML translation in your database

Stanislav KhromovStanislav Khromov

WPML String Translation only seems to search in the original language (English) and not in existing translations.

So to find which english string corresponds to an already translated text, you can do this:

SELECT * FROM wp_icl_string_translations, wp_icl_strings WHERE wp_icl_string_translations.value="Translated text in any language!" AND = wp_icl_string_translations.string_id;

Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
Twitter Profile
Visit my other blog

Comments 0
There are currently no comments.