/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 vote207 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote338 views1 answer
Mysql data from file
SQL
0 vote182 views1 answer
Hive batch drop table
SQL
0 vote178 views2 answers
Find Overlapping sql
SQL
1 vote181 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
2 votes234 views1 answer
Mysql shell insert into
SQL
5 votes223 views2 answers
Postgresql insert select
SQL
0 vote186 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote195 views1 answer
Postgresql inheritance
SQL
4 votes191 views2 answers
Select first and last row mysql
SQL