/SQL/Change old domain to new domain name wordpress

Change old domain to new domain name wordpress

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';

UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');

UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');

Source: stackoverflow.com

Similar codes

24 votes205 views5 answers
List mysql users
SQL
10 votes192 views1 answer
User_dependencies
SQL
0 vote204 views1 answer
Postgresql function ROUND
SQL
0 vote184 views2 answers
Raise notice in postgresql function
SQL
0 vote142 views1 answer
Mssql view column data type
SQL
5 votes214 views1 answer
Oracle asynchronous query
SQL
0 vote209 views1 answer
Sql_inner_join
SQL
1 vote202 views1 answer
Psql view enum values
SQL
2 votes192 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
1 vote193 views1 answer
Show all event schedular on mysql
SQL