Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Semrush - keyword research tool

Linux Foundation Training and Certification

Teach Your Child To Read

Disclosure: My content contains affiliate links.

32,308 questions

42,483 answers

573 users

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

2 Answers

0 votes
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


answered Jan 9, 2023 by avibootz
0 votes
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


answered Jan 9, 2023 by avibootz
...