Patients with a Condition in MySQL
Intuition\n Describe your first thoughts on how to solve this problem. \nPatients with Type I Diabetes always starts with DIAB1 prefix.\n\n# Approach\n Describe
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\nPatients with Type I Diabetes always starts with `DIAB1` prefix.\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\n> `wildcard characters` \u2192 These characters are used to substitute one or more characters in a string\n> `LIKE` \u2192 This operator searches for a specified pattern in a column\n> `OR` \u2192 This operator displays a record if any of the conditions separated by it are TRUE\n\n# Code\n```\n# Write your MySQL query statement below\nSELECT *\nFROM patients\nWHERE conditions LIKE \'% DIAB1%\' OR \nconditions LIKE \'DIAB1%\'\n```
['MySQL']