How to change all the guid in posts table?

It should be something like:

UPDATE wp_posts SET guid = REPLACE(guid, 'oldurl.com', 'newurl.com') WHERE guid LIKE 'http://oldurl.com/%';

• oldurl.com – Previous URL shown in wordpress settings > general options
• newurl.com – New URL