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.


XenForo developer
Staff member
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
As always, we recommend taking a backup before running queries against the database.