Search and Replace in MySQL Database
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")
Categories: Blogs, Bookmarks, MySQL, Tech, Wordpress MySQL REPLACE, phpMyAdmin, replace string in database, SQL query
