Question

How to replace http:// to https:// in MySQL with SQL

Answer 1

UPDATE table_name
     SET url = REPLACE(url, 'http://', 'https://')
     WHERE url LIKE 'http://%';

 

Learn & Practice Python
with the most comprehensive set of 13 hands-on online Python courses
Start now

Answer 2

UPDATE table_name
     SET url = REPLACE(url, 'http://', 'https://')
     WHERE url LIKE '%http://%';

 

Learn & Practice Python
with the most comprehensive set of 13 hands-on online Python courses
Start now