MySQL: 2 solutions
Using simple string matching:\n\nSELECT * FROM Patients\nWHERE conditions LIKE \'%DIAB1%\';\n\n\nUsing regular expression match:\n\nSELECT * FROM Patients\nWHER
Using simple string matching:\n```\nSELECT * FROM Patients\nWHERE conditions LIKE \'%DIAB1%\';\n```\n\nUsing regular expression match:\n```\nSELECT * FROM Patients\nWHERE conditions REGEXP \'^DIAB1| DIAB1\';\n```\n\nThe REGEXP version is more robust.
[]