/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 vote109 views1 answer
How to create an SQL save method in ruby
SQL
0 vote113 views1 answer
Sqlite update only if greater
SQL
0 vote114 views1 answer
How should I pass a table name into a stored proc?
SQL
-1 vote128 views1 answer
Auto increment psql not primary key
SQL
0 vote104 views1 answer
Edit a field mysql terminal
SQL
0 vote123 views1 answer
Sql constarint
SQL
12 votes106 views5 answers
Sql primary key
SQL
0 vote116 views1 answer
Add a new column into table
SQL
1 vote105 views4 answers
Sql now
SQL
0 vote117 views1 answer
How to select a row in sql
SQL