Contact: aviboots(AT)netvision.net.il
32,308 questions
42,483 answers
573 users
UPDATE table_name SET url = REPLACE(url, 'http://', 'https://') WHERE url LIKE 'http://%';
UPDATE table_name SET url = REPLACE(url, 'http://', 'https://') WHERE url LIKE '%http://%';