MySQL queries

[Andy]

phpMyAdmin -> xf_post -> SQL

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

Note: this update is case insensitive.

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]

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.