MyBB Community Forums

Full Version: Replace some text in Mybb Database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I have a link to a site from some posts of my site which is now banned by google.

I want to replace that link with some other link.

Please tell me what is the SQl Query for that and how to run it ?

For Vbulletin I know the query is
UPDATE post
SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')

Please help Smile

Thankyou
Try
UPDATE mybb_posts SET message = REPLACE(message,'OLD TEXT','NEW TEXT')
where i apply these codes??
^ at your database manager (eg. phpMyAdmin) see http://community.mybb.com/thread-44380.html