XF 1.5 Change the internal forum links with MySQL

[Robru]

Which mysql command I can use to change the internal forum links:

From:

https://www.caviaforum.nl/threads/

to:

https://www.caviaforum.nl/community/threads/

 

[Paul B]

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

Just change current_content and new_content to suit.

 

[Robru]

And how for links in signatures and conversations?

 

[Paul B]

Just change the table/field like so:

UPDATE xf_user_profile SET signature = REPLACE(signature,'current_content','new_content');

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

 

[Robru]

Thank you Brogan