Select Page

How to search and replace in MySQL database with phpMyAdmin ?

Click on your database name, you want to run the search and replace through. Next, click on the SQL tab, in the SQL box, enter something like:

UPDATE table_name SET table_field = replace(table_field,"find_string","replace_string");
For example:

UPDATE table_spip_articles SET text = replace(text,"" , "");

and execute 🙂