2 DIFFERENT SOLUTIONS | Efficient solution
Soltion 1\n\nSELECT * FROM patients WHERE conditions REGEXP \'\\\\bDIAB1\'\n\n\n\nSolution 2 | Efficient\n\nSELECT *\nFROM Patients\nWHERE conditions LIKE \'% D
Soltion 1\n```\nSELECT * FROM patients WHERE conditions REGEXP \'\\\\bDIAB1\'\n```\n\n\nSolution 2 | Efficient\n```\nSELECT *\nFROM Patients\nWHERE conditions LIKE \'% DIAB1%\' OR conditions LIKE \'DIAB1%\'\n```\n\n
['MySQL']