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

XF 1.4 What is the correct SQL query to run, find replace on post and conversations?

Discussion in 'XenForo Questions and Support' started by RoldanLT, Dec 1, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    Like I want to replace all:

    https://xenforo.com
    with
    http://xenforo.com

    In all post and conversation message.
    Thanks a lot!
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
    
    UPDATE xf_conversation_message SET message = REPLACE(message,'current_content','new_content');
     
    Terror, Recep Baltaş and RoldanLT like this.
  3. RoldanLT

    RoldanLT Well-Known Member

    Works great, Thanks a lot Brogan.
    How about profile post and signature?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_profile_post SET message = REPLACE(message,'current_content','new_content');
    
    UPDATE xf_profile_post_comment SET message = REPLACE(message,'current_content','new_content');
    
    UPDATE xf_user_profile SET signature = REPLACE(signature,'current_content','new_content');
     
    Recep Baltaş and RoldanLT like this.
  5. RoldanLT

    RoldanLT Well-Known Member

    Solved, Thanks :)
     

Share This Page