/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

3 votes196 views1 answer
Oracle limit user tablespace
SQL
0 vote182 views1 answer
Alter table myisam to innodb
SQL
16 votes191 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
2 votes132 views1 answer
Select sid oracle
SQL
0 vote220 views1 answer
Find wordpress version in database
SQL
0 vote255 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote320 views1 answer
Postgres set column based on another column
SQL
14 votes176 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote195 views1 answer
TSQL convert csv to table
SQL
0 vote185 views1 answer
Mysql bash execute sql file
SQL