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

XF 1.1 Regular Expressions

Discussion in 'XenForo Questions and Support' started by DBA, Apr 12, 2012.

  1. DBA

    DBA Well-Known Member

  2. Brogan

    Brogan XenForo Moderator Staff Member

    A simple SQL query will do that.

    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    So in your case:
    UPDATE xf_post SET message = REPLACE(message,'http://www.domain.com/content/','http://www.domain.com/threads/');
    Take a backup first, just in case.
  3. DBA

    DBA Well-Known Member

    Thanks, I was over thinking it, forgot I could do it this way.

    BTW shouldn't the replace be http://www.domain.com/ otherwise it'd end up being http://www.domain.com/thread/thread/?
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

Share This Page