# 1527. 患某种疾病的患者
# https://leetcode-cn.com/problems/patients-with-a-condition/

# SQL架构
Create table If Not Exists Patients (patient_id int, patient_name varchar(30), conditions varchar(100));
Truncate table Patients;
insert into Patients (patient_id, patient_name, conditions) values ('1', 'Daniel', 'YFEV COUGH');
insert into Patients (patient_id, patient_name, conditions) values ('2', 'Alice', '');
insert into Patients (patient_id, patient_name, conditions) values ('3', 'Bob', 'DIAB100 MYOP');
insert into Patients (patient_id, patient_name, conditions) values ('4', 'George', 'ACNE DIAB100');
insert into Patients (patient_id, patient_name, conditions) values ('5', 'Alain', 'DIAB201');

# Write your MySQL query statement below
select
    patient_id,
    patient_name,
    conditions
from
    Patients
where
    conditions regexp '^DIAB1| DIAB1';

# clean-up
drop table Patients;