/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 vote208 views1 answer
Postgres row expiration
SQL
1 vote202 views1 answer
Sql where max date
SQL
5 votes210 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote193 views1 answer
Mysql config slave
SQL
0 vote170 views1 answer
Get number of table colums in sql query
SQL
23 votes201 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote193 views2 answers
Changes not showing on website server odoo
SQL
0 vote204 views1 answer
How to install postgresql on wsl
SQL
0 vote218 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote214 views1 answer
Selecting all columns from table sql database
SQL