/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

1 vote140 views1 answer
How to get mysql db size
SQL
16 votes159 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote158 views2 answers
Oracle select
SQL
0 vote158 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote165 views1 answer
Mariadb create index if not exists
SQL
0 vote177 views1 answer
Sql query for login with email or username
SQL
7 votes146 views3 answers
Sql update where id
SQL
7 votes164 views2 answers
Where keyword sql
SQL
0 vote148 views1 answer
Run sql script file and changes db name in this file using c#
SQL
5 votes186 views1 answer
How to use rank function in sql
SQL