Replace a string in all posts of your forum
#1
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 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.
Reply


Messages In This Thread
Replace a string in all posts of your forum - by Sector - 2012-07-17, 08:09 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)