/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

0 vote219 views4 answers
What is unique key in sql
SQL
2 votes211 views3 answers
Sql server reseed identity column
SQL
-2 votes213 views1 answer
No module named '_sqlite3
SQL
0 vote211 views2 answers
Athena drop partition
SQL
0 vote188 views1 answer
Import sql mysql ubuntu
SQL
0 vote215 views1 answer
Create table split string function in sql server
SQL
0 vote164 views0 answer
SQL
0 vote210 views1 answer
Create mysql pool connection python flask
SQL
0 vote221 views1 answer
Mysql best varchar length size
SQL
0 vote216 views1 answer
Get the Db column names from a SqlDataReader
SQL