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 votes295 views1 answer
Sql update alias
SQL
0 vote333 views1 answer
How to find date from date table in sql
SQL
7 votes295 views2 answers
Mysql db size
SQL
1 vote291 views1 answer
Sql query row number group by
SQL
2 votes290 views1 answer
Oracle current date without time
SQL
2 votes277 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
2 votes298 views1 answer
Oracle convert run_duration to number
SQL
0 vote308 views1 answer
Geopoint from json mysql function
SQL
0 vote282 views2 answers
What is 1=2 in sql
SQL
3 votes287 views5 answers
Mysql get last inserted id
SQL