What are the rules to use like.
Does like work in two condition and and operator also.
Like select from User where name="John" and hobbies like "%Football%";
Where hobbies is a long string with comma seprated multiple values.
This will work or not?
Yes and No
The wildcard chars are correct but your expression is in error. Select what??
SELECT ??? FROM User WHERE name="John" AND hobbies LIKE "%Football%"
tHANKS SOMETIMES YOU MISS BASIC THINGS AND START WORKING ON COMPLEX THINGS.