/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 votes177 views1 answer
Sql server version query
SQL
0 vote171 views1 answer
Sql server current time without date
SQL
1 vote181 views1 answer
Right outer vs left outer join
SQL
17 votes183 views5 answers
Order by sql
SQL
10 votes180 views1 answer
Dba_dependencies
SQL
0 vote180 views1 answer
Sql trigger to call stored procedure with parameters
SQL
3 votes174 views1 answer
Sql cast to integer
SQL
2 votes191 views1 answer
Mysql change data type of column
SQL
3 votes185 views1 answer
Mssql remove column
SQL
11 votes169 views1 answer
How to get ddl for materialized view
SQL