Delete all IMG tags in WordPress posts with specified domain

Here are two SQLs for WordPress.

Delete IMG with given Domain in Posts/ Pages

UPDATE wp_posts
SET post_content = REGEXP_REPLACE(post_content, '< img[ ^> ]+src=[ \'" ][ ^\'" ]*domain\.net[ ^\'" ]*[ \'" ][ ^> ]*> ', '')
WHERE post_content REGEXP '< img[ ^> ]+src=[ \'" ][ ^\'" ]*domain\.net[ ^\'" ]*[ \'" ][ ^> ]*> '; 

Replace http to https SQL in Posts/ Pages

UPDATE wp_posts
SET post_content = REPLACE(post_content, 'http://', 'https://')
WHERE post_content LIKE '%http://%';