/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

0 vote224 views1 answer
Left join in codeigniter query builder
SQL
0 vote237 views1 answer
Mysql make date from 2 column
SQL
0 vote278 views1 answer
Find and replace query in wordpress\
SQL
0 vote231 views1 answer
Get week day name sql server
SQL
0 vote233 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote265 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
-1 vote241 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote245 views1 answer
Select tables with name like mysql
SQL
0 vote249 views1 answer
Prodection ready postgres database step by step
SQL
0 vote222 views1 answer
Raiserror nowait sql server
SQL