Code: Select all
http://www.old_example.com
[url][/url]
BBCode are stored like:Code: Select all
http://www.old_example.com
:
is encoded as :
and the full stop .
is encoded as .
.Code: Select all
UPDATE phpbb_posts SET post_text = REPLACE(post_text, 'www.old_example.com', 'www.new_example.com');
UPDATE phpbb_posts SET post_text = REPLACE(post_text, 'www.old_example.com', 'www.new_example.com');
phpbb_
, and the names of the old and new domains. For the second query make sure you maintain the syntax by using HTML entities as appropriate.