-- first is old SITE URL
-- second is new SITE URL


-- UPDATE `wp_tbl` SET `this_col` = REPLACE(`this_col`, 'OLD_URL', 'NEW_URL');


UPDATE `wp_options` SET `option_value` = REPLACE(`option_value`, 'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic') WHERE `option_name` = 'home' OR `option_name` = 'siteurl';
UPDATE `wp_posts` SET `post_content` = REPLACE (`post_content`, 'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_posts` SET `post_excerpt` = REPLACE (`post_excerpt`, 'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_postmeta` SET `meta_value` = REPLACE (`meta_value`,'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_termmeta` SET `meta_value` = REPLACE (`meta_value`, 'http://192.168.1.119/freak_template_blank/wp_clinic','http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_comments` SET `comment_content` = REPLACE (`comment_content`, 'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_comments` SET `comment_author_url` = REPLACE (`comment_author_url`,'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');
UPDATE `wp_posts` SET `guid` = REPLACE (`guid`, 'http://192.168.1.119/freak_template_blank/wp_clinic', 'http://localhost/freak_template_blank/wp_clinic');