How to find and replace database use phpMyAdmin

0

Last modified: April 21, 2014


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.


find-and-replace-database-use-phpmyadmin

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. SQL Query Search and Replace Script in PHP
  2. Search and Replace in WordPress

SQL Query Search and Replace Script in PHP

1. Login to phpMyAdmin and select your database

Login to phpMyAdmin and select your database

2. Click the SQL tab

phpMyAdmin and click 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

Search and Replace in WordPress

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:

Search and Replace

 

Search and Replace

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

Search and Replace for WordPress

MORE / INFO

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.

Share.

About Author

I'm a freelance with over 3 years experience working in PHP with CMS Wordpress and design website layout. In my spare time, I go fishing, lean internet marketing, scout new blogging strategies,free Xbox live gold codes and techniques, and work from wherever. View me on: Google+ | Facebook.

Leave A Reply