Replace images URL to HTTPS ones in WordPress

update_image_links_to_ssl.sql

UPDATE  wp_posts 
SET     post_content = ( Replace (post_content, 'src="http://', 'src="//') )
WHERE   Instr(post_content, 'jpeg') > 0 
        OR Instr(post_content, 'jpg') > 0 
        OR Instr(post_content, 'gif') > 0 
        OR Instr(post_content, 'png') > 0;
        
UPDATE  wp_posts 
SET     post_content = ( Replace (post_content, "src='http://", "src='//") )
WHERE   Instr(post_content, 'jpeg') > 0 
        OR Instr(post_content, 'jpg') > 0
        OR Instr(post_content, 'gif') > 0 
        OR Instr(post_content, 'png') > 0;
        
UPDATE  wp_postmeta 
SET     meta_value=(REPLACE (meta_value, 'iframe src="http://','iframe src="//'));