/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 vote351 views1 answer
DATEDIFF minute postgres
SQL
54 votes546 views6 answers
Sql rename column
SQL
0 vote329 views1 answer
PSQL qith variables
SQL
8 votes333 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote353 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote338 views1 answer
Docker open terminal mysql server
SQL
7 votes315 views4 answers
How to reset the identity column in sql server
SQL
0 vote356 views2 answers
Soql last year
SQL
0 vote364 views1 answer
Prodection ready postgres database step by step
SQL
-1 vote377 views2 answers
Import data from excel to sql server automatically
SQL