/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

1 vote277 views1 answer
Encrypt password postgresql
SQL
8 votes378 views2 answers
Select current_timestamp - interval '3 days';
SQL
6 votes273 views2 answers
How to copy data in sql
SQL
1 vote315 views2 answers
Laravel jwt generate token
SQL
0 vote268 views1 answer
Sql mod even odd
SQL
0 vote266 views1 answer
Sum values by month mariadb
SQL
7 votes279 views1 answer
Mysql iif
SQL
5 votes264 views1 answer
Postgresql functions
SQL
0 vote287 views1 answer
Order child below the parent in mysqli
SQL
2 votes373 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL