Hi!
How can I replace an address with new address in my forum.
I want to change all of "iriboard.com/up" to "up.iranbiologists.com"
Thanks
Does this URL is inside the post(s) ?
USE AT YOUR OWN RISK, TEST FIRST ON A COPY OF THE TABLES
UPDATE mybb_posts SET message = replace(message, 'iriboard.com/up', 'up.iranbiologists.com') WHERE message LIKE '%iriboard.com/up%'
UPDATE mybb_templates SET template = replace(template, 'iriboard.com/up', 'up.iranbiologists.com') WHERE template LIKE '%iriboard.com/up%'
excellent!
Thanks a lot!
rep+
Don't think you need the WHERE statement.
UPDATE mybb_posts SET message = replace(message, 'iriboard.com/up', 'up.iranbiologists.com');
You would need a WHERE if you had a different parameter like WHERE pid=X or WHERE tid="Y"...but since you're already doing a full search for the term you don't need it in the WHERE.