/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

7 votes361 views2 answers
Add column table pl sql
SQL
5 votes327 views1 answer
Mysql select greater than yesterday
SQL
0 vote350 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote346 views1 answer
Mysql date time string format python
SQL
1 vote369 views2 answers
Logical operators in sql
SQL
0 vote342 views2 answers
How to update the multiple rows in sql
SQL
2 votes335 views1 answer
Oracle trace session
SQL
0 vote388 views1 answer
Sql query wordpress export post
SQL
0 vote355 views1 answer
Postgres read table structure
SQL
2 votes350 views1 answer
Get first n letter of department name in sql
SQL