/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 vote303 views1 answer
Order by monthly in sql
SQL
4 votes325 views2 answers
Mysql delete user if exists
SQL
13 votes290 views5 answers
Oracle list tables
SQL
0 vote409 views1 answer
Delet all record statment sql
SQL
0 vote326 views1 answer
Raiserror with nowait
SQL
11 votes339 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes325 views2 answers
Tsql join multiple record in one string
SQL
0 vote302 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote318 views1 answer
Allow external access to mysql
SQL
0 vote320 views1 answer
Sql comand for removing data from table
SQL