Mass Replace String in MySQL Table Database

There are two practical methods suggested:

1st solution: save/copy the database table and

• – use text editor’s “search and replace” function and fill table with new content;
• – remove (empty) old table from database
• – upload new/modified table to database

2nd solution , use MySQL REPLACE function:

UPDATE table_name SET column_name =

REPLACE(column_name,”original_text”,”replace_text”)

And that’s it, happy coding !