Mass Replace String in MySQL Table Database
There are basically 2 ways suggested method:
- 1st, save/copy the database table and use text editor’s “search and replace” function and fill table with new content;
- 2′nd , use MySQL REPLACE function:
UPDATE table_name SET column_name = REPLACE(column_name,"original_text","replace_text")
