wordpress mysql find and replace localizers

wordpress mysql find and replace localizers

update wp_posts set guid           = replace(guid,         'simplehelix.com', 'com');
update wp_posts set post_content   = replace(post_content, 'simplehelix.com', 'com');
update wp_options set option_value = replace(option_value, 'simplehelix.com', 'com');
update wp_postmeta set meta_value  = replace(meta_value,   'simplehelix.com', 'com');

mySQL wordpress localizer, helpful find and replace mysql commands for use after moving from a dev address to a production address.
in the example, we're going from 'mysite.simplehelix.com' to 'mysite.com'