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?

Code:
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

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