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 vote124 views1 answer
Sql show founctions
SQL
0 vote118 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote166 views1 answer
Example database query
SQL
0 vote126 views1 answer
Delete hangfire retries list
SQL
3 votes119 views1 answer
Laravel paginate raw sql
SQL
0 vote120 views1 answer
We are intrested to work with your organization
SQL
0 vote120 views1 answer
Select last 2 characters sql
SQL
7 votes124 views3 answers
Python and mysql connectivity
SQL
0 vote118 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
62 votes154 views8 answers
Mysql add column
SQL