that is a very bad way to do that IMO – you may well be changing links for sites that do not support SSL
you should be doing only the site domain (http://example.com)
it gets even more involved however … i’m no expert and found your post because i’m wanting to the same thing to my site – i intended on using the Search & Replace plugin to change all tables in the db…
find: http://example.com replace: https://example.com
i asked my host about this and the guy seems very good at what he does and he works with WP constantly – he suggested this is a better way…
find: http://example.com replace: //example.com
omitting http/https does indeed work and this let’s the visitors browser decide what is best instead of forcing anything
HOWEVER…
even that is apparently a bad thing if you use the S&R plugin (or run a global SQL query) because this will update the GUID part of the wp_posts table and, apparently, that is a big fat no-no…
WP Codex: Changing The Site URL
quote:
When doing the above and changing the URLs directly in the database, you will come across instances of the URL being located in the “guid” column in the wp_posts tables.
It is critical that you do NOT change the contents of this field.
…which is why i’m here – i want to ask the devs of this plug about that because it appears that it will always modify wp_posts GUID if the table is selected and if the search string matches content in the GUID
Yeah I did that with a couple sites but didn’t feel good about it. Since then I have just changed the main URL like you said. I think i originally thought to do all http to https because there was still lots of SSL issues on the site i was switching over. Anyways ill stick to just doing the website domain, and work on each other issue that pops up.
The plugin helps you to change from http to https, however you should have links inside the theme or plugin that is not fixed via S/R plugin, is more an manual change inside the code.