/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 vote193 views1 answer
How to access to mysql without root
SQL
0 vote177 views1 answer
Custom row number
SQL
0 vote253 views1 answer
Sql select max value for each group
SQL
0 vote199 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote211 views1 answer
Find wordpress version in database
SQL
2 votes206 views1 answer
Dbms transaction (psql)
SQL
0 vote171 views1 answer
MySql count occurences more than"
SQL
0 vote201 views1 answer
Sqlite get date only
SQL
0 vote195 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote191 views1 answer
Postgres copy command
SQL