XF 1.4 Mysql Query to change url

[kankan]

Hi,
What would be the mysql query to change urls in post and conversation from :
http://www.xxxx.com/www/threads/thread_title.id/xxxxx to
http://www.xxxx.com/forums/threads/thread_title.id/xxxxx

www change to forums

thanks!

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'old','new');

Take a backup first.