SQL Guide : solidDB® SQL statements : Common clauses : search_condition
  
search_condition
search_condition
 
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 }
Spaces on each side of the operator are optional.
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 } )
If the IN clause contains only one item, parenthesis are not needed. ::= expression [NOT] IN value
For example:
SELECT * FROM MY_TABLE1 WHERE A IN 2; SELECT * FROM MY_TABLE1 WHERE A IN (2,3,6);
quantified_test
::= expression { = | <> | < | <= | > | >= } [ALL | ANY | SOME] subquery
existence Jest
::= EXISTS subquery
See also
Common clauses