• 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?

RoldanLT

Well-known member
#1
Like I want to replace all:

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

In all post and conversation message.
Thanks a lot!
 

Brogan

XenForo moderator
Staff member
#4
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');