Find and Replace in MySQL

I just move my Blogs from alwaysdata and now set it up at heliohost. And like usual copy the WordPress installation, dump the databases,etc. Wondering how easy using cPanel to maintain all activity and now I’ve parked domain using .co.cc. Instead using domain given by heliohost, I prefer use a short word :) Yes, it’s just bowo.co.cc. Just little thing, I wondering how to migrate the databases since there are some value of databases that refers to my old website. Before it, I just use find and replace on sql file and then import those sql file, but its kind of traditional. Googlin’ around to find out the better way… And voila.. Using MySQL replace function.

I do it from phpMyAdmin, but it should run also from MySQL console without any problems. The basic syntax is:

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");

And I tested mine….

UPDATE `wp_posts` SET guid = replace(guid,'bowo.heliohost.org','bowo.co.cc') WHERE `post_date` REGEXP '2009';

WHERE clause can be added onto this as well.