Skip to content
Andrey Gershun edited this page May 27, 2015 · 2 revisions

IN

Syntax:

    expression IN array

AlaSQL supports IN operatior:

    SELECT a FROM one WHERE b IN (1,2,3)
    SELECT a FROM one WHERE b IN (SELECT b FROM two)
    SELECT a FROM one WHERE b IN ?

In the expression:

    expression IN @(expression)

like:

    10 IN @(?)
    @a IN @(@b)
    20 IN @(@[10,20,30])

See the example in jsFiddle

See also: [NOT IN](Not In), EXISTS

Clone this wiki locally