/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 vote284 views1 answer
Sql delete caracter list
SQL
1 vote203 views1 answer
List all triggers in SQL Server
SQL
0 vote222 views1 answer
Oracle show grants on table
SQL
0 vote188 views1 answer
Declare date variable sql
SQL
0 vote203 views1 answer
Sql pad left 0
SQL
7 votes325 views2 answers
Mysql default value
SQL
0 vote153 views1 answer
Sqlalchemy filter relationship
SQL
1 vote183 views4 answers
Sql now
SQL
0 vote197 views2 answers
Mysql output csv
SQL
0 vote270 views1 answer
Month mysql
SQL