XF 1.5 Xenforo equivalent of this vB SQL query

Joe Blow

Active member
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.