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

1 vote333 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote320 views1 answer
Sql contains numeric characters
SQL
1 vote350 views1 answer
Sql server if exists update else insert
SQL
1 vote301 views1 answer
Postgresql filter on
SQL
13 votes304 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes308 views1 answer
Import large .sql files into lampp
SQL
0 vote303 views1 answer
Order by monthly in sql
SQL
0 vote323 views1 answer
Oracle sql count occurrences of value in column
SQL
-1 vote333 views1 answer
Auto increment psql not primary key
SQL
0 vote300 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL