Mass Replace String in MySQL Table Database
June 13th, 2008
No comments
use MySQL REPLACE function!
1. BACKUP YOUR DATABASE FIRST.
2. From within phpMyAdmin, open your database.
3. And here is the SQL query to replace string in database table:
UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string")