SQL snippet para sustituir http: por https:

Busca si tienes ‘http:’  (en lugar de https:)

SELECT * FROM wp_posts WHERE post_content LIKE '%http:%'

Sustituye con está expresión

update wp_posts set post_content = replace(post_content, 'http:', 'https:');

1 Comment on “SQL snippet para sustituir http: por https:

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.