IN Operator


The IN operator checks whether OPERAND-A is found in OPERAND-B, where OPERAND-B is a comma-separated list of 1–1024 values (or expressions).
OPERAND-A and the members of OPERAND-B should be of the same type — either strings or integers.

For example, "genre IN ('Rock', 'Blues', 'R&B')" checks whether the value of a “genre” string attribute is identical to one of the genre strings in OPERAND-B (“Rock”, “Blues”, or “R&B”).