/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 vote303 views1 answer
Postgresql not in alternative
SQL
1 vote295 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote328 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote314 views1 answer
How to set sql_mode for a query in CI model
SQL
19 votes339 views5 answers
Display table in sql
SQL
0 vote292 views2 answers
How to find max and min salary in sql
SQL
0 vote293 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
1 vote317 views1 answer
Add many column to sap iq table
SQL
0 vote303 views1 answer
Oracle c# multiple update sql
SQL
0 vote286 views1 answer
Go install mysql
SQL