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 SQL from A to Z at LearnSQL.com

Answer 2

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

 

Learn SQL from A to Z at LearnSQL.com