/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

8 votes156 views2 answers
Sqlsrv default port
SQL
0 vote139 views1 answer
Execut sql python
SQL
2 votes147 views1 answer
Sqlite indexes
SQL
1 vote143 views1 answer
Sql bitwise operators
SQL
0 vote100 views1 answer
Get all stored procedures in sql server
SQL
10 votes112 views2 answers
Sql where clause multiple values
SQL
0 vote140 views1 answer
Mysql workbench format date
SQL
0 vote141 views1 answer
C# mysql update statement set value to null
SQL
2 votes156 views2 answers
Change mysql password from command line
SQL
0 vote136 views1 answer
Mysql command line ubuntu
SQL