Optimal Solution
\nselect*\nfrom patients\nwhere conditions like \'% DIAB1%\' or conditions like \'DIAB1%\'\n\n\n%operator specifies that there can be any number of charachters\
```\nselect*\nfrom patients\nwhere conditions like \'% DIAB1%\' or conditions like \'DIAB1%\'\n```\n\n%operator specifies that there can be any number of charachters\nlike in first condition the first % operator states there can be any number of characters before the " DIAB1" while the second one specifies that there can be any no of characters after " DIAB1".\n\nUpvote if you find it useful.
['MySQL']