/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 vote121 views1 answer
Python mysql query to dataframe
SQL
5 votes106 views1 answer
Oracle get nls settings
SQL
0 vote118 views1 answer
Mysql date format unix timestamp
SQL
4 votes122 views3 answers
Count with where
SQL
0 vote135 views1 answer
Selecting all columns from table sql database
SQL
0 vote135 views1 answer
Full outer join in mariadb mysql
SQL
8 votes160 views6 answers
Insert command in sql
SQL
1 vote119 views1 answer
Md5 encryption for existing records
SQL
0 vote114 views1 answer
Oracle sql developer closed connection
SQL
1 vote106 views1 answer
Use of now() in mysql
SQL