/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 vote220 views1 answer
Sql delimiter to columns
SQL
4 votes226 views1 answer
Postgresql change default value
SQL
11 votes191 views1 answer
Reset identity sql server
SQL
0 vote256 views1 answer
T-sql update table variale
SQL
1 vote223 views1 answer
User privileges postgresql information_schema
SQL
3 votes229 views1 answer
Oracle rollback
SQL
18 votes216 views3 answers
Mysql current date
SQL
0 vote233 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote256 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote221 views2 answers
Sql regex vowel
SQL