코테준비 | Patients With a Condition (문자열 추출 - 정규표현식 REGEXP , 특정문자기준 슬라이싱 - SUBSTRING_INDEX)
·
SQL
☑️  Patients With a Condition[문제]Write a solution to find the patient_id, patient_name, and conditions of the patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix.'DIAB1' 가 접두사인 값 모두 출력 [문제 풀이]코드1 - LIKESELECT *FROM PATIENTS WHERE conditions LIKE 'DIAB1%' OR conditions LIKE '% DIAB1% 코드2 - REGEXP SELECT *FROM PATIENTS WHERE conditions REGEXP '^DIAB1' OR conditi..