wordpress - replace url

sql

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Update Domain fixed

UPDATE wp_options SET option_value = replace(option_value, 'http://100.29.7.22', 'http://www.ohionational.pe') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://100.29.7.22','http://www.ohionational.pe');

UPDATE wp_posts SET post_content = replace(post_content, 'http://100.29.7.22', 'http://www.ohionational.pe');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://100.29.7.22','http://www.ohionational.pe');

Restore old one

UPDATE wp_options SET option_value = replace(option_value, 'http://www.ohionational.pe', 'http://100.29.7.22') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid,'http://www.ohionational.pe','http://100.29.7.22');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.ohionational.pe', 'http://100.29.7.22');

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.ohionational.pe', 'http://100.29.7.22');

Restore http to https

UPDATE wp_options SET option_value = replace(option_value, 'http://www.ohionational.pe', 'https://www.ohionational.pe') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid,'http://www.ohionational.pe','https://www.ohionational.pe');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.ohionational.pe', 'https://www.ohionational.pe' );

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.ohionational.pe', 'https://www.ohionational.pe');

UPDATE wp_options SET option_value = replace(option_value, 'http://www.ohionational.pe', 'http://100.29.7.22') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid,'http://www.ohionational.pe','http://100.29.7.22');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.ohionational.pe', 'http://100.29.7.22' );

UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.ohionational.pe', 'http://100.29.7.22' );