/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 vote212 views1 answer
Access mysql database docker container shell
SQL
1 vote221 views1 answer
Get table column names sql ssms
SQL
2 votes221 views1 answer
Oracle insert or update
SQL
0 vote241 views1 answer
Check constraint is violated
SQL
10 votes196 views2 answers
Mysql select timestamp group by day
SQL
1 vote232 views1 answer
Key validation sql
SQL
0 vote231 views1 answer
Oracle table privileges
SQL
5 votes228 views4 answers
Start postgres server
SQL
1 vote237 views3 answers
Rows, INSERT INTO
SQL
21 votes237 views1 answer
SQL cheat sheet pdf
SQL