Ideally, I'd like to do this with a find/replace type MySQL query (to avoid editing the phrases individually through the admin panel).
I looked at the database and saw two two tables that look relevant. They're named xf_phrase_compiled and xf_phrase.
Which table is the correct one on which to run the query? Or does the fact the phrases are compiled mean I can't update this correctly by running a query on the database?
Or is there an easier way built in that I've completely overlooked?
Any help is greatly appreciated!