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://%';

 

70+ SQL courses for beginners and professionals

Answer 2

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

 

70+ SQL courses for beginners and professionals