/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 vote195 views1 answer
Loading local data is disabled mysql
SQL
0 vote199 views2 answers
How to save result of sqlite query in a table
SQL
0 vote159 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
9 votes208 views3 answers
Find all tables with column name
SQL
0 vote210 views1 answer
Mysql type for large numbers with many decimal
SQL
10 votes221 views4 answers
Inner join in update query mysql
SQL
14 votes225 views2 answers
Oracle add attribute to table
SQL
0 vote168 views2 answers
Delete the last item in a table sql
SQL
0 vote200 views1 answer
Plpgsql raise notice
SQL
0 vote238 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL