Search and Replace MySQL using PHPMyAdmin. This is simple tutorial to help you do a find and replace in any MySQL database in phpMyAdmin. Please remember backup your database before do it.
This is step by step guide how to find and replace database for your Grid and. This SQL query method is extremely helpful when you need to replace multiple text strings and do not wish to export the entire database just to make those changes.
1. Login to phpMyAdmin and select your database
2. Click the SQL tab
3. Enter the following in the run SQL Query text box (replacing tablename, tablefield, findstring and replacestring with your actual information
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
4. Click go to process the changes and update your SQL database
If you are using wordpress blog and do not want to access phpMyAdmin so i will show a useful plugin which help you replace your datatase simplest by install this wordpress plugin:
A simple search for find strings in your database and replace the string. You can search in ID, post-content, GUID, titel, excerpt, meta-data, comments, comment-author, comment-e-mail, comment-url, tags/categories and categories-description. It is possible to replace the user-ID in all tables and the user-login for more security in the WordPress-Application ( more Informations ).
A another WordPress plugins may useful for you
Search and Replace for WordPress
I hope that helps! I use find and replace all the time and having this tool available to you will make your edits and changes much easier.