update wp_posts set post_content = replace(post_content,'http://classic-literature.co.uk','https://classic-literature.co.uk');
After running this SQL command every WordPress Post, WordPress Page and WordPress Attachment Page main content will have all the internal http links changed to https links.
To run another SQL command under Virtualmin click the blue “Return to execute SQL Form” button.
Continue Reading Change WordPress Site from HTTP to HTTPS