picoSQL - Language reference manual

6.3) IN predicate

IN predicate compare an expression with a group of values; the syntax is:

expression [NOT] IN (value-1[ ,value-2] ...)

This predicate, without the NOT operator, is equivalent to:

expression = value-1 [ OR expression = value-2] ...

NOT operator reverses the meaning of the condition.