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

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