Really useful bit of SQL that allows you to find and replace any bit of text within a WordPress post or page. Very useful for whenn migrating a WordPress database.
UPDATE `wp_posts` SET post_content = replace(post_content,'http://www.kineticpulse.co.uk/wordpress25/'
,'http://www.101datasolutions.co.uk/');
Also the follow SQL statement can be used if the guids of all the posts are still pointing to the old domain:
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');