Cacher is the code snippet organizer for pro developers

UPDATE wp_posts SET wp_posts.guid=REPLACE(wp_posts.guid,
'olddomain.com',
'newdomain.com'
);
UPDATE wp_options SET wp_options.option_value='http://newdomain.com' WHERE wp_options.option_name='siteurl' OR wp_options.option_name='home';