MyBB Community Forums

Hi
I want to update my all posts.
I want to replace all iranbiologists.com in posts with forum.iranbiologists.com

How can i do it?

UPDATE mybb_posts SET message = REPLACE(message,'TEXT_TO_REPLACE','NEW_TEXT');

Make sure your database prefix is mybb_

Edit: delayed response

you can try query like below

UPDATE mybb_posts SET message = REPLACE(message, 'iranbiologists.com', 'forum.iranbiologists.com') WHERE message LIKE '%iranbiologists.com%'

Thanks a lot!