/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

5 votes352 views1 answer
Purge undo tablespace usage
SQL
38 votes332 views4 answers
Count sql
SQL
3 votes305 views2 answers
Mysql add 2 hours
SQL
0 vote338 views1 answer
Helptext in sql
SQL
0 vote294 views2 answers
Sql update from two different database
SQL
19 votes330 views5 answers
Change column name mysql command line
SQL
19 votes334 views6 answers
Sql drop table if exists
SQL
0 vote359 views2 answers
Mysql missin expression near on
SQL
8 votes369 views1 answer
See all users mysql
SQL
0 vote322 views1 answer
Sqlite update where exists
SQL