/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 vote284 views1 answer
Count mysql server db tables
SQL
1 vote289 views1 answer
SQL date part only of datetime
SQL
-1 vote298 views1 answer
Sql show custom constraints
SQL
7 votes265 views1 answer
Mysql unsafe update
SQL
0 vote293 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote291 views1 answer
Interview experience as a call?
SQL
8 votes301 views1 answer
Oracle search code in packages
SQL
5 votes291 views1 answer
Mysql created at yesterdau
SQL
2 votes280 views1 answer
Oracle trace session
SQL
0 vote271 views1 answer
Restore backup "text" postgresql command line
SQL