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 vote362 views2 answers
Mysql update two tables at once
SQL
0 vote318 views1 answer
Remove from table where
SQL
1 vote359 views1 answer
Round function in sql oracle
SQL
-1 vote331 views1 answer
Mysql #1064 error
SQL
0 vote347 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
1 vote345 views1 answer
Drush sql-dump
SQL
0 vote349 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote374 views1 answer
Space not removing from column in sql
SQL
0 vote364 views1 answer
Insert into table with only identity column
SQL
0 vote324 views1 answer
Oracle character index
SQL