Search and Replace MySQL using PHPMyAdmin

Search and Replace MySQL using PHPMyAdmin

This is a life-saver: an easy way to search any table inside your database and replace one string of text with another. It works like a charm. But be careful, search first to see the results of your query before you commit the changes, and always backup prior to any database work.

Here is how you test the waters safely:

SELECT * FROM `wp_posts` WHERE `post_content` LIKE '%oops%'

Translation:

SELECT * FROM `table_name` WHERE `field_name` LIKE '%unwanted_text%'

And here is how you do some damage:

UPDATE `wp_posts` SET `post_content` = replace(post_content, 'oops', 'much better')

And translated:

UPDATE `table_name` SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

Comments

One Response to “Search and Replace MySQL using PHPMyAdmin”

  1. Gosip Artis Terbaru on December 5th, 2008 6:21 pm

    great, this is what i’m looking for. thanks for sharing

Got something to say?