/SQL/Wordpress change http to https phpmyadmin

Wordpress change http to https 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

1 vote259 views1 answer
Drush sql-dump
SQL
2 votes258 views2 answers
How to check data type in sql server
SQL
0 vote268 views1 answer
Mysql change innodb to myisam
SQL
0 vote259 views1 answer
Mysql where in keep order
SQL
4 votes255 views1 answer
Add constraint fk
SQL
2 votes254 views2 answers
Get all tables using like
SQL
0 vote266 views1 answer
Set root password mysql xampp
SQL
0 vote251 views2 answers
Auto increment column in mysql query results
SQL
1 vote278 views1 answer
How to get the date diff on once field in sql server
SQL
3 votes290 views1 answer
Sql double index
SQL