XF 1.4 Find/Replace in Phrases

[PrettyPixels]

I need to replace the word "Resource" with "Story" throughout all the Resource Manager phrases.

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!

 

[Mike]

You can't really do it via a query. It needs to be done in the control panel.

 

[PrettyPixels]

Thanks for your quick reply, Mike! After looking around the database, I suspected this was probably the case.