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

rdn

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');
 
Top