Find and replace URL in WP

UPDATE wp_posts SET guid=replace(guid, 'http://old.url', 'http://new.url');
UPDATE wp_posts SET post_content=replace(post_content, 'http://old.url', 'http://new.url');

first i check the table prefix before i run the query

[11:58]
to make sure it is actually wp_

[11:59]
then look at the values in the guid column

[11:59]
of the posts table

[11:59]
to get the exact URL(s) could be multiple versions

[11:59]
actually the very first step is to copy a dump of the wp_posts data