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

0 vote208 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
10 votes145 views1 answer
Oracle view dependencies
SQL
0 vote168 views1 answer
Function plsql
SQL
17 votes145 views6 answers
Mysql import sql file
SQL
-1 vote183 views2 answers
Sql search all tables for attributes
SQL
25 votes159 views4 answers
Sqlserver add column
SQL
2 votes163 views2 answers
Change mysql password from command line
SQL
0 vote156 views1 answer
Kill slow queries mysql
SQL
4 votes167 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
9 votes139 views1 answer
Mysql check date range
SQL