Wordpress Migration search and replace for db

gistfile1.txt

UPDATE wp_options SET option_value = REPLACE(option_value, ':8080', '');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ':8080', '');
UPDATE wp_posts SET post_content = REPLACE(post_content, ':8080', '');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, ':8080', '');
UPDATE wp_posts SET guid = REPLACE(guid, ':8080', '');