1527. Patients With a Condition / LeetCode, SQL, MySQL

문제

source: LeetCode

Write an SQL query to report the patient_id, patient_name and conditions of the patients who have Type I Diabetes. Type I Diabetes always starts with DIAB1 prefix.
Return the result table in any order.

 

 

 

 

제출답안(MySQL)

SELECT patient_id, patient_name, conditions
FROM patients
WHERE conditions REGEXP'^DIAB1|.* DIAB1|DIAB1$'

 

 

 

문제 바로가기(MySQL)