Wordpress sql change site url

# Check your table prefix
# Change all the tables 

UPDATE wp_options SET option_value = 
replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' 
OR option_name = 'siteurl';UPDATE wp_posts SET guid = 
replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Source: hostinger.com

Similar codes

1 vote198 views3 answers
Postgresql crete view
SQL
19 votes206 views5 answers
Display table in sql
SQL
0 vote176 views1 answer
Find most frequent value in SQL column
SQL
0 vote168 views2 answers
How to relationship query two different tables in MySQL
SQL
4 votes182 views3 answers
Mysql modify foreign key
SQL
2 votes185 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
4 votes167 views1 answer
SQL order random
SQL
0 vote178 views1 answer
Alter table add check constraint oracle
SQL
0 vote196 views1 answer
How to combine rows in sql server procedure
SQL
0 vote184 views1 answer
Postgresql replace html tags from string
SQL