/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 vote147 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote144 views1 answer
Limiting query result using where in sql
SQL
0 vote171 views1 answer
How to create a table in sql stack overflow
SQL
0 vote161 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote170 views1 answer
Sql order by except one row
SQL
0 vote179 views1 answer
How to get parent and child record in single query using sql
SQL
3 votes156 views3 answers
Postgresql random number
SQL
-1 vote165 views1 answer
Count occurrences sql
SQL
0 vote160 views1 answer
How to query without duplicate rows in sql
SQL
-2 votes168 views1 answer
Mysql see users and passwords
SQL