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

[rdn]

Like I want to replace all:

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

In all post and conversation message.
Thanks a lot!

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

UPDATE xf_conversation_message SET message = REPLACE(message,'current_content','new_content');

 

[rdn]

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

 

[Paul B]

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

 

[rdn]

Solved, Thanks