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

9 votes157 views4 answers
SQL Date Format
SQL
0 vote150 views1 answer
Raiserror nowait sql server
SQL
0 vote159 views1 answer
Oracle sql copy table without data
SQL
0 vote168 views1 answer
Mysql pv progres
SQL
0 vote179 views1 answer
Manage Database in MySQL
SQL
7 votes185 views3 answers
Sql server check if temp table exists
SQL
0 vote178 views1 answer
Varchar format not case sensitive sql
SQL
0 vote192 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
2 votes181 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote181 views1 answer
Add sequence postgres
SQL