Web Design Philippines | MikeWagan.net

Search and Replace in MySQL

Nov 30, 2009 web development

I just went through a domain transfer for one of our websites, and the links in the posts are all pointing to OldSite.com rather than the NewSite.com. But it’s an easy fix, as long as you got Google.

I searched around and a very easy and quick way to search and replace text in a MySQL database is this query:
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
You can also use WHERE clause to filter your query. An example would be:
UPDATE `mos2_content` SET introtext = replace(introtext,"<p>","") WHERE `title` REGEXP '-0';
This one removes all<p> tags from the posts. Hope this helps you guys looking how to search and replace text in mysql.

Source: Zimmertech

Related posts:

1. How To Repair Corrupted MySQL Tables in Linux I had this problem for days and can’t find a solution. What I had was .frm, .MYD and .MYI backup...