/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

3 votes280 views2 answers
Mysql update row
SQL
19 votes265 views5 answers
Mysql between date range
SQL
5 votes245 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote412 views3 answers
Create table from existing table in sql
SQL
0 vote241 views1 answer
Database springboot
SQL
1 vote266 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote259 views2 answers
Sql multiline comment
SQL
0 vote249 views1 answer
Sql create table with references not primary key
SQL
0 vote284 views1 answer
Add super privilege mysql
SQL
0 vote247 views1 answer
Get who is hired in january in sql
SQL