Oracle Easy Regex Solution
\nSELECT * FROM patients\nWHERE REGEXP_LIKE(conditions, \'(^| )DIAB1\')\n\nThis is the same as:\n\nSELECT * FROM patients\nWHERE conditions LIKE \'% DIAB1%\' OR
```\nSELECT * FROM patients\nWHERE REGEXP_LIKE(conditions, \'(^| )DIAB1\')\n```\nThis is the same as:\n```\nSELECT * FROM patients\nWHERE conditions LIKE \'% DIAB1%\' OR conditions LIKE \'DIAB1%\';\n```\n(^| ): This part of the pattern uses the | (alternation) operator within parentheses to match either the start of the string ^ or a space character
['Oracle']