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 vote174 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote158 views1 answer
Change default schema sql server
SQL
1 vote217 views1 answer
Postgresql where datetrunc month and year equal
SQL
10 votes177 views3 answers
Sql select between two dates
SQL
2 votes179 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote182 views2 answers
Mysql insert into multiple tables
SQL
0 vote167 views2 answers
Sql last updated
SQL
0 vote173 views1 answer
Initcap in mysql
SQL
0 vote173 views1 answer
Mysql workbench primary key
SQL
0 vote161 views1 answer
How to output a different column name in mysql
SQL