SQL query to search and change prefixes

[Morrus]

I need to add large numbers of thread prefixes based on keywords in the thread titles. At the moment, I'm spending hours laboriously searching for keywords, opening threads, editing them, and saving them again- all one at a time. There are inline prefix change mods around, but they don't work on the search results pages.

Could anyone advise on the SQL query I'd need to run to do the following:

Change thread prefix to X for all threads in Forum Y whose title contain the string Z.

(e.g. change thread prefix to Apples for all threads in Food Forum whose titles contain the word "apple").

Thanks in advance for any help!