ESQL operators overview

An ESQL operator is a character or symbol that you can use in expressions to specify relationships between fields or values.

ESQL supports the following groups of operators:

  • Comparison operators, to compare one value to another value (for example, "less than"). Refer to ESQL simple comparison operators and ESQL complex comparison operators for details of the supported operators and their use.
  • Logical operators, to perform logical operations on one or two terms (for example, AND). Refer to ESQL logical operators for details of the supported operators and their use.
  • Numeric operators, to indicate operations on numeric data (for example, +). Refer to ESQL numeric operators for details of the supported operators and their use.

There are some restrictions on the application of some operators to data types; not all lead to a meaningful operation. These are documented where they apply to each operator.

Operators that return a Boolean value (TRUE or FALSE), for example the "greater than" operator, are also known as predicates.