Search and Replace in MySQL

I found something very handy today, search and replace on Mysql databases. You can do it on phpmyadmin or make a php script with this. After moving a wordpress site from server I discovered that all image links were broken because they are placed directly inside each post. They were still linking to the old server. Changing it manually would be a nightmare. Luckily MySql is your friend. To search and replace a text string, start up phpMyAdmin, and click on your database name that you want to run the search and replace through....

October 22, 2009 · 1 min · 123 words · David Amador