XF 1.5 Xenforo equivalent of this vB SQL query

[Joe Blow]

Hi folks,

What is the Xenforo equivalent of the following vBulletin database search and replace SQL query?

UPDATE post SET pagetext = replace(pagetext, 'OLDTEXT', 'NEWTEXT');

I used to use this query a lot to replace out of date or malformed links.

Thanks for your help.

 

[Mike]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

As always, we recommend taking a backup before running queries against the database.

 

[Joe Blow]

Thanks Mike.

 

[Alpha1]

Have you seen @Kier 's addon?
https://xenforo.com/community/resources/post-content-find-replace.1549/