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

2 votes185 views1 answer
Postgresql transaction
SQL
8 votes189 views1 answer
Show mysql user table
SQL
0 vote186 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote202 views1 answer
Postgresql custom order by
SQL
1 vote210 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote180 views1 answer
Oracle check table space
SQL
0 vote174 views1 answer
Oracle date summer time
SQL
8 votes175 views3 answers
Alter user root mysql
SQL
0 vote200 views1 answer
Sqlite explain plan
SQL
23 votes185 views1 answer
How remove column in mysql
SQL