Easy to Understand | SQL
\nselect\n    patient_id,\n    patient_name,\n    conditions\nfrom\n    patients\nwhere\n    conditions like \'% DIAB1%\'  #any condition in middle like ACNE DI
```\nselect\n    patient_id,\n    patient_name,\n    conditions\nfrom\n    patients\nwhere\n    conditions like \'% DIAB1%\'  #any condition in middle like ACNE DIAB100\n    or\n    conditions like \'DIAB1%\';   #starts with DIAB1\n```\n\nIf you have any **doubts**, feel **free to ask**...\nIf you understand the **concept**. Don\'t Forget to **upvote**\n\n
['MySQL']