XF 1.5 change http to https in posts (sql?)

[Biarritz64]

hi
i move my site to https

the think is that i have more than 600 url in the posts of my forum that still refer to old url http://

whats is the best method to remplace url in posts that point to my site with http (to https)

can i do sql find and replace url in database? how?

thank you for your help

 

[Paul B]

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

Take a backup first in case something goes wrong and you need to restore.

 

[Biarritz64]

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

Take a backup first in case something goes wrong and you need to restore.

It workes for me
thank you

 

[MrC]

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

Take a backup first in case something goes wrong and you need to restore.

Hi,

Do I need to rebuild anything? I used that code to change from http to https but only a few links updated. Other links still show http, but when I edited them, they show the correct https links.