/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 vote311 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote320 views1 answer
Fill up postgres db
SQL
0 vote312 views1 answer
Sql waitfor
SQL
0 vote329 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote313 views1 answer
Kill thread
SQL
-1 vote348 views1 answer
Create view in mysql workbench
SQL
0 vote349 views1 answer
Reset postgres table index to next max value
SQL
4 votes332 views2 answers
Installing sql on ubuntu
SQL
2 votes387 views3 answers
Mysql unix timestamp to date
SQL
0 vote299 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL