search‑condition
The search‑condition clause has the following syntax:
search‑condition::= search‑item | search‑item {AND | OR} search‑item
search‑item::= [NOT] {search‑test | (search‑condition)}
search‑test::= comparison‑test | between‑test | like‑test | null‑test | set‑test | quantified‑test | existence‑test
comparison‑test::= expression {= | <> | < | <= | > | >=} {expression | subquery}
between‑test::= column‑identifier [NOT] BETWEEN expression AND expression
like‑test::= column‑identifier [NOT] LIKE value [ESCAPE value]
null‑test::= column‑identifier IS [NOT] NULL
set‑test::= expression [NOT] IN ({value [, value ] … | subquery})
quantified‑test::= expression {= | <> | < | <= | > | >=} [ALL | ANY | SOME] subquery
existence‑test::= EXISTS subquery
Go up to