Execute Custom SQL Commands in Virtualmin

Execute Custom SQL Commands in Virtualmin

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 Moving a WordPress Site from HTTP to HTTPS SEO Guide