• 
  

  
  

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')

Related posts:

1. Search and Replace a Custom Field in WordPress using PHPMyAdmin
2. How to Bulk Import into a MySQL Database
3. How to Add Uploaded Media to WP-DownloadManager
4. Delete Comment Spam using a Cron Job
5. Replace Text on Click Using JavaScript

Comments

• Visit counter: 45469
  
• 
  
  
  

• More in 'MySQL'

  • Delete Comment Spam using a Cron Job
  • How to Add Uploaded Media to WP-DownloadManager
  • How to Bulk Import into a MySQL Database
  • Search and Replace a Custom Field in WordPress using PHPMyAdmin
  • Search and Replace MySQL using PHPMyAdmin

• More in 'Ubuntu'

  • This Kernal Requires the Following Features Not Present on the CPU: 0:6
  • How to Display Your “Uptime” using Bash
  • My Top 10 Ubuntu Aliases
  • Delete Comment Spam using a Cron Job
  • How to Add Uploaded Media to WP-DownloadManager

• More in 'WordPress'

  • Redirect Users Back to Page They Were On
  • Replace Text on Click Using JavaScript
  • Delete Comment Spam using a Cron Job
  • How to Add Uploaded Media to WP-DownloadManager
  • Search and Replace a Custom Field in WordPress using PHPMyAdmin