Updating a string
UPDATE wp_posts SET guid = REPLACE(guid, 'inforum.dev', 'inforum.xyz') WHERE guid LIKE '%inforum.dev%'