Wordpress change url phpmyadmin

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

4 votes198 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote323 views1 answer
How to get table current identity value in sql server
SQL
19 votes209 views6 answers
What is mySQL
SQL
0 vote245 views1 answer
Compress sql file database ubuntu
SQL
0 vote251 views1 answer
SQL get max per id
SQL
0 vote252 views1 answer
Import sql inside hide sql
SQL
1 vote280 views1 answer
Find size of all DB's postgres
SQL
4 votes205 views2 answers
Oracle unlock user
SQL
0 vote203 views1 answer
How to see password mysql vestacp
SQL
0 vote201 views1 answer
Oracle shrink table
SQL