/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 vote57 views1 answer
Java nosql sort
SQL
0 vote43 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote39 views1 answer
Back up stored procedures mysql
SQL
0 vote57 views1 answer
Sql datum formatieren
SQL
1 vote47 views1 answer
Funzioni plsql
SQL
3 votes43 views1 answer
Sql replace character in string in all records
SQL
1 vote50 views3 answers
Showing all columns in an sqlite table
SQL
4 votes63 views4 answers
Remove duplicate old value in mysql
SQL
0 vote63 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote40 views1 answer
Mysql select where text contains
SQL