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://%';