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.


Index Previous Next