• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Query to change a text from all database

Claudio

Well-known member
#1
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?
 

Brogan

XenForo moderator
Staff member
#2
Code:
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.