/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 vote279 views1 answer
Denied
SQL
3 votes484 views9 answers
Linq to sql converter online
SQL
0 vote358 views1 answer
Change role postgres
SQL
0 vote358 views2 answers
Temp Space
SQL
0 vote333 views2 answers
Csv into data postgres
SQL
0 vote355 views1 answer
Postrgres trunc
SQL
0 vote338 views4 answers
How to connect form to database
SQL
0 vote314 views1 answer
Create domain sql
SQL
25 votes337 views6 answers
Change column name mysql
SQL
0 vote345 views3 answers
Sql server import json
SQL