/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

3 votes129 views2 answers
To_char oracle
SQL
0 vote150 views2 answers
Sqlalchemy default value for column
SQL
0 vote149 views1 answer
How to change mysql root password in windows 10
SQL
3 votes134 views1 answer
Postgresql cast
SQL
0 vote114 views1 answer
Jooq finding lastest value in table
SQL
1 vote140 views1 answer
Mysql get max value and id
SQL
1 vote153 views2 answers
Drop table with constraints
SQL
15 votes163 views4 answers
Mysql export database command line
SQL
13 votes150 views5 answers
Sql default
SQL
4 votes148 views4 answers
Pl sql output
SQL