/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

22 votes238 views4 answers
Date format mysql
SQL
7 votes180 views5 answers
Show details of table postgres
SQL
0 vote164 views1 answer
Duplicate foreign key constraint name
SQL
2 votes182 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote134 views1 answer
Get all stored procedures in sql server
SQL
0 vote176 views1 answer
Will graphql replace sql
SQL
1 vote194 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote159 views1 answer
Dnsmasq.conf location macos
SQL
1 vote186 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
-1 vote192 views2 answers
Create temporary table sql
SQL