XF 1.1 Query to change a text from all database

[Claudio]

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?

 

[Paul B]

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.

 

[Claudio]

thanks! it worked