1. 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

Discussion in 'XenForo Questions and Support' started by Claudio, Nov 29, 2011.

  1. Claudio

    Claudio 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?
  2. Brogan

    Brogan 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.
    Frankxd likes this.
  3. Claudio

    Claudio Well-Known Member

    thanks! it worked :)

Share This Page