# Package org.h2.expression.condition

Condition expressions.

See: Description

Class Summary
BetweenPredicate: BETWEEN predicate.
BooleanTest: Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
CompareLike: Pattern matching comparison expression: WHERE NAME LIKE ?
Comparison: Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
ConditionAndOr: An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
ConditionAndOrN: An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.
ConditionIn: An 'in' condition with a list of values, as in WHERE NAME IN(...)
ConditionInArray: Quantified comparison predicate with array.
ConditionInConstantSet: Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.
ConditionInQuery: An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)
ConditionLocalAndGlobal: A global condition or combination of local and global conditions.
ConditionNot: A NOT condition.
ExistsPredicate: Exists predicate as in EXISTS(SELECT ...)
IsJsonPredicate: IS JSON predicate.
NullPredicate: Null predicate (IS [NOT] NULL).
SimplePredicate: Base class for simple predicates.
TypePredicate: Type predicate (IS [NOT] OF).
UniquePredicate: Unique predicate as in UNIQUE(SELECT ...)

Enum Summary
CompareLike.LikeType: The type of comparison.

## Package org.h2.expression.condition Description

Condition expressions.