/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
Postgresql inheritance
SQL
0 vote170 views1 answer
Set mysql socket file docker windows
SQL
1 vote162 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote180 views2 answers
Sqlalchemy core in clause
SQL
1 vote190 views2 answers
Oracle leftmost characters
SQL
1 vote169 views1 answer
Pv mysql import
SQL
0 vote177 views1 answer
Data types mysql vs postgresql
SQL
0 vote183 views1 answer
List in one column mysql
SQL
10 votes173 views1 answer
Oracle dependencies table
SQL
0 vote156 views1 answer
Stuff in sql server
SQL