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

0 vote130 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote121 views1 answer
Sql right characters
SQL
0 vote136 views1 answer
Mysql select where field is a value
SQL
1 vote150 views1 answer
Sql in array query
SQL
3 votes178 views1 answer
Oracle function
SQL
14 votes141 views1 answer
Excel is not a database
SQL
0 vote140 views1 answer
Sql values not in another table
SQL
10 votes144 views4 answers
Join multiple tables in sql
SQL
2 votes125 views2 answers
Mysql user access to database
SQL
1 vote121 views1 answer
Delete triger pl pg sql
SQL