/SQL/Wordpress database query change url

Wordpress database query change url

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

Similar codes

1 vote145 views2 answers
Mysql order by date asc null last
SQL
1 vote148 views1 answer
Oracle add proxy
SQL
0 vote159 views1 answer
Sql on-premises
SQL
1 vote196 views1 answer
Backup mysql schema only
SQL
0 vote197 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote152 views1 answer
Get duplicate entry sql
SQL
1 vote149 views1 answer
Mysql count words
SQL
0 vote149 views1 answer
Mysql export search results
SQL
0 vote132 views1 answer
Sql examples from your work
SQL
5 votes174 views3 answers
Db begintransaction laravel
SQL