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 (https://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: https://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: https://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
