2012-07-17, 08:09 PM
Warning: Always backup your database first in case something goes wrong.
If you need to replace some word or name in all posts of your forum, run this query:
UPDATE
You may want be selective and add a WHERE
Remember to be careful when using queries and always double check what you are doing.
If you need to replace some word or name in all posts of your forum, run this query:
UPDATE
mybb_posts
SET message
= REPLACE(message
, "Old String", "New String")You may want be selective and add a WHERE
field
=Etc if you only want to replace that string in certain posts, or in a given timeframe.Remember to be careful when using queries and always double check what you are doing.