/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 vote204 views1 answer
How to input data as id in database sql c#
SQL
0 vote177 views1 answer
Mysql local password denied
SQL
0 vote173 views1 answer
Bidirectional outer join sql
SQL
2 votes188 views1 answer
Sql percentage with % rounded down
SQL
0 vote192 views1 answer
Sql max of two values
SQL
0 vote206 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote168 views3 answers
Create and attach user to a postgresql database
SQL
1 vote168 views1 answer
Mysql alter decimal precision
SQL
0 vote187 views1 answer
Postgres change the name of schema
SQL
4 votes252 views1 answer
Select first and last row sql
SQL