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?