Wordpress change url in database

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');

Source: wpbeaches.com

Wordpress sql change site url

# Check your table prefix
# Change all the tables 

UPDATE wp_options SET option_value = 
replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' 
OR option_name = 'siteurl';UPDATE wp_posts SET guid = 
replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Source: hostinger.com

Similar codes

1 vote172 views1 answer
How to check all scheduled jobs in oracle
SQL
4 votes114 views1 answer
Sql data types
SQL
2 votes115 views2 answers
How to view created temporary tables in mysql
SQL
0 vote129 views1 answer
Mysql where in maintain order
SQL
1 vote139 views1 answer
How to get previous year from sysdate in oracle
SQL
1 vote119 views1 answer
Return size of tables in mysql
SQL
3 votes105 views1 answer
Oracle get trigger ddl
SQL
24 votes115 views4 answers
Delete db postgres
SQL
1 vote79 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote73 views1 answer
Store query result in variable sql
SQL