XF 1.1 Query to change a text from all database


Well-known member
I recently changed my forum domain to a newer one...

the problem is that all posts from my foro keeps with links to other threads from it but with the old domain.

so I was wondering to search in the database for all "www.myolddomain.com" text and replace it by "mynewdomain.com". Does anyone know which query I should use to do that?


XenForo moderator
Staff member
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
Replace current_content with your old domain URL and new_content with your new domain URL.