/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

1 vote315 views1 answer
Sql headers delphi
SQL
0 vote297 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote286 views1 answer
Input in mysql
SQL
0 vote279 views1 answer
Get all employees if name ends with in sql
SQL
10 votes277 views2 answers
Mysql select timestamp group by day
SQL
4 votes321 views3 answers
Sql drop database if exists
SQL
6 votes334 views3 answers
Create database mysql utf8
SQL
-1 vote295 views3 answers
Update mongodb version ubuntu
SQL
5 votes305 views1 answer
Ora-00054 find lock
SQL
2 votes326 views2 answers
How to add not null constraint in sql
SQL