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="">

    I copied all the images to a directory in my forum domain:

    I need to replace in all posts with

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



    Nach dem Update ist vor dem Update. :S

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!