Replace text in all posts via database

  • Affected Version
    WoltLab Suite 5.2

    How to replace text in all posts via database?


    I had images hosted on another site so code in posts for embedded images looks like this <img src="http://imagehosting.com/image/picture.jpg">


    I copied all the images to a directory in my forum domain: https://myforum.com/image/


    I need to replace in all posts http://imagehosting.com with https://myforum.com


    Which table do I run the query on and what should the query be? Thank you.

  • Like this UPDATE wbb1_post SET `message`= REPLACE(`message`,'http://imagehosting.com/image/','https://myforum.com/image/');

    Greetz

    Dark


    Nach dem Update ist vor dem Update. :S