/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 vote315 views1 answer
Codeigniter dbforge add index
SQL
0 vote331 views1 answer
Sqlite explain plan
SQL
0 vote396 views2 answers
Mysql insert rows to another database
SQL
1 vote299 views1 answer
Mysql select utc time in eastern time
SQL
0 vote336 views1 answer
Top frequency in sql server
SQL
0 vote334 views1 answer
Oracle lower in where clause
SQL
0 vote306 views1 answer
Replace sqlalchemy
SQL
0 vote322 views1 answer
Sql count more than 1
SQL
1 vote314 views2 answers
Populate sql table with random data
SQL
0 vote304 views1 answer
Sql select rows between 1000 and 2000
SQL