/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 vote123 views1 answer
Mysql find db contarint
SQL
2 votes116 views1 answer
Oracle current date without time
SQL
0 vote118 views1 answer
Online sql testing tool
SQL
4 votes134 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote130 views1 answer
Select * from mysql.proc
SQL
3 votes123 views3 answers
Create a view postgres
SQL
0 vote127 views1 answer
Import mysql'
SQL
0 vote123 views1 answer
Create table sql generator
SQL
1 vote145 views1 answer
Oracle extract minute from date
SQL
1 vote130 views1 answer
Sql server locks
SQL