I have old data that has been migrated into a new design. The old data contains multi-language data using 4 different languages and Transcribe.
The new site does not contain transcribe, nor does it need the articles in the other languages. But all other articles in english need to be included.
I need to close all entries that are written in these other languages. Removing Transcribe didn't close the entries. In the url_title column in the exp_channel_titles row, the language prefix is included. So I can search for ru, ar, fa - etc in this row, filter them out, and set the status to closed if the strings ru, ar, fa, etc are found.
So I'd like to search for all entries that contain "ar" and bulk close them. I'd imagine there is a way to do this via sql query.
I was able to write:
UPDATE exp_channel_titles a ON a.url_title = '"-ru"' SET a.status = "closed";based on the response below, but that gave me a syntax error. I'm not sure that = will find a string, it seems like an exact search, I could be wrong.