/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 vote107 views1 answer
Exectuer myssql .sql
SQL
0 vote100 views1 answer
Sql pivot without aggregate
SQL
0 vote99 views1 answer
Sql select merge multiple values
SQL
0 vote159 views1 answer
How to get number of months between 2 dates sql server
SQL
2 votes94 views1 answer
Wait delay in sql server
SQL
-1 vote98 views1 answer
Can pandas fetch data from sql
SQL
1 vote136 views3 answers
How to update column name in psql
SQL
0 vote119 views1 answer
Sqlite unique multiple columns
SQL
1 vote104 views1 answer
Mysql strict_trans_tables
SQL
17 votes109 views4 answers
Mysql remove ubuntu
SQL