/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 vote275 views1 answer
Create new table in SQL from old table with data
SQL
20 votes264 views4 answers
Reset auto increment in MySQL
SQL
0 vote260 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
18 votes281 views6 answers
Creating table in MySQL
SQL
2 votes277 views1 answer
Add new column not null sql server
SQL
32 votes292 views6 answers
How to change column name in sql
SQL
3 votes421 views9 answers
Linq to sql converter online
SQL
0 vote225 views1 answer
Mysql offset from bottom
SQL
0 vote273 views1 answer
Reona
SQL
7 votes295 views1 answer
Mysql remote connection command line
SQL