/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 votes269 views1 answer
Postgres update column with value from another table
SQL
6 votes269 views5 answers
Get current date sql
SQL
0 vote317 views1 answer
How to inner join 4 tables in sql
SQL
0 vote309 views1 answer
Mysql bash execute sql file
SQL
0 vote286 views1 answer
Frename oracle
SQL
1 vote301 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
2 votes302 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
4 votes279 views3 answers
Drop Table Oracle
SQL
-1 vote300 views5 answers
Left join
SQL
1 vote286 views1 answer
Postgres cast as currency format
SQL