• Welcome to XF2 Addons. You can buy my Premium membership for $35 per year, and this gives you access to download any or ALL of the 300 add-ons that I have developed for Xenforo 2.x. In addition, Premium members will get technical support. Once the Premium membership has expired you can continue to use the installed addons on your forum as long as you like.

MySQL queries


Andy

Administrator
Staff member
phpMyAdmin -> xf_post -> SQL

Add the following SQL query to update text in a post.

Note: this update is case insensitive.

Code:
UPDATE xf_post SET message = REPLACE(message, 'current content', 'new content')
Make sure you have a recent database backup to restore from should something go wrong.
 

Andy

Administrator
Staff member
Always make sure the 'current content' is unique. For example this is safe:

[QUOTE="Graham Smith,

This is not safe:

[QUOTE="Graham

because there could be more than one Graham.
 
Similar threads
Thread starter Title Forum Replies Date
Andy MySQL tuner Server Information 2
Andy MySQL - max_connections Server Information 2
Andy Show MySQL variables Server Information 2

Similar threads

Top