/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

53 votes430 views6 answers
Sql server alter column
SQL
0 vote259 views1 answer
Compare if is null sql
SQL
0 vote239 views1 answer
Count column of tables psql
SQL
1 vote264 views1 answer
Psql lst trigger
SQL
0 vote282 views2 answers
Connect to mysql server mac terminal
SQL
7 votes300 views2 answers
Sql remove duplicates based on column
SQL
1 vote244 views1 answer
Firebase bigquery cloud message
SQL
0 vote292 views2 answers
Disallowed function mysql to_date()
SQL
0 vote265 views1 answer
Sql server select furst day of current year
SQL
4 votes255 views1 answer
Sql query to make a existing column auto increment
SQL