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.
 
Thread starter Similar threads Forum Replies Date
Andy MySQL - max_connections Server Information 2
Andy Show MySQL variables Server Information 2

Similar threads

Top