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 votes265 views2 answers
Spring where to put the data sql
SQL
1 vote241 views1 answer
Oracle lowercase
SQL
0 vote287 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote276 views1 answer
Shrink database file in sql server
SQL
3 votes258 views2 answers
How to start postgresql on windows
SQL
0 vote287 views1 answer
Hibernate dialect property xml for mysql 8
SQL
-1 vote246 views3 answers
Mysql get age from date
SQL
11 votes266 views1 answer
Oracle insert into where
SQL
2 votes266 views1 answer
Datetrunc
SQL
3 votes249 views3 answers
Sql current year
SQL