Find a string and replace it the whole database

admin

Administrator
Staff member
I have a wordpress website and I'm going to change it's URL. The problem is that when I search for its actual URL in the database, I have like 200 results.

I would like to search in the whole database for the actual url and replace it with the new one.

I know that if I have the exact table and exact column, I can do :

Code:
UPDATE
    Table
SET
    Column = Replace(Column, 'find value', 'replacement value')

But how can I generalize this code to my whole database ?

Thank You !