✅🔥💯Easy MySQL Solution || 3 Approaches || Beats - 94% || (⁠◍⁠•⁠ᴗ⁠•⁠◍⁠)
Intuition\nThe code shows three solutions-\n- Using Wildcard Characters\n- Using LOCATE() function\n- Using POSITION() function\n\n# Code\nmysql []\nselect pati
# Intuition\nThe code shows three solutions-\n- Using Wildcard Characters\n- Using LOCATE() function\n- Using POSITION() function\n\n# Code\n```mysql []\nselect patient_id, patient_name, conditions\nfrom patients \nwhere conditions like \'DIAB1%\' OR\n    conditions like \'% DIAB1%\';\n\n--  USING LOCATE(substring, string)\n-- where locate("DIAB1" , conditions ) = 1\n-- or locate(" DIAB1" , conditions ) <> 0;\n\n--  USING POSITION(substring IN string )\n-- where position("DIAB1" IN conditions ) = 1\n-- or position(" DIAB1" IN conditions ) <> 0;\n```\n\n**Upvote** the post if it was helpful in any way and you liked it!\nComment down for any doubts or suggestions.\n\nSigning off,\nArcturus_22\n
['Database', 'MySQL']