/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

6 votes95 views2 answers
Oracle undotbs usage
SQL
0 vote153 views1 answer
Placements hackerrank solution
SQL
0 vote131 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote110 views1 answer
Mysql average from two table
SQL
0 vote120 views3 answers
Mysqli count down
SQL
-1 vote109 views2 answers
Installing mysql on centos 7
SQL
0 vote108 views1 answer
Add alternate add column sql
SQL
0 vote96 views1 answer
Mysql sql select one day before
SQL
0 vote110 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote100 views1 answer
Mysql_error replacement
SQL