SQL Operators

A summary of the SQL operator support in ChaosSearch

SQL Arithmetic Operators

OperatorDescription
+Add
-Subtract
*Multiply
/Divide
%Modulo

SQL Comparison Operators

OperatorDescription
=Equals
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
<>Not equal to

SQL Logical Operators

OperatorDescription
ALLTRUE if all of the subquery values meet the condition
ANDTRUE if all the conditions separated by AND are TRUE
ANYTRUE if any of the subquery values meet the condition
BETWEENTRUE if the operand is within the range of comparisons
EXISTSTRUE if the subquery returns one or more records
INTRUE if the operand is equal to one in a list of expressions
LIKETRUE if the operand matches a pattern. The LIKE pattern is case sensitive, and the pattern supports two symbols for matching:

_ matches any single character.

% matches zero or more characters.

Typically LIKE is used as a condition in WHERE statements. For example, to find all continents starting with E which returns Europe, you could use a LIKE pattern such as:

SELECT \* FROM region_view WHERE continent LIKE 'E%';
NOTDisplays a record if one or more conditions are NOT TRUE
ORTRUE if any of the conditions separated by OR is TRUE
SOMETRUE if any of the subquery values meet the condition