Simple Logic 🎈
\n# Approach\nThis Question is simple one but has one simple logic which is confusing a lot. \nSELECT * FROM PATIENTS WHERE\nCONDITIONS LIKE \'% DIAB1%\' OR CON
\n# Approach\nThis Question is simple one but has one simple logic which is confusing a lot. \n`SELECT * FROM PATIENTS WHERE\nCONDITIONS LIKE \'% DIAB1%\' OR CONDITIONS LIKE \'DIAB1%\';`\nThis Code will work for all the test cases but will fail for the last one because in it  `DIAB1`  is there but it in the between and we have to return null but this condition `%DIAB1%` will not give null so You have to just add `\'% DIAB1%\'` space before the word so the it will check only for the word where there is space at the Starting.\n# Code\n```\n# Write your MySQL query statement below\nSELECT * FROM PATIENTS WHERE\nCONDITIONS LIKE \'% DIAB1%\' OR\nCONDITIONS LIKE \'DIAB1%\';\n\n```\n![1qivbn.jpg](https://assets.leetcode.com/users/images/a169dbd7-b34d-4a99-8359-a8a813239d9a_1689869293.2703924.jpeg)
['MySQL']