SQL Operators
A summary of the SQL operator support in ChaosSearch
SQL Arithmetic Operators
Operator | Description |
---|---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Modulo |
SQL Comparison Operators
Operator | Description |
---|---|
= | Equals |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
SQL Logical Operators
Operator | Description |
---|---|
ALL | TRUE if all of the subquery values meet the condition |
AND | TRUE if all the conditions separated by AND are TRUE |
ANY | TRUE if any of the subquery values meet the condition |
BETWEEN | TRUE if the operand is within the range of comparisons |
EXISTS | TRUE if the subquery returns one or more records |
IN | TRUE if the operand is equal to one in a list of expressions |
LIKE | TRUE if the operand matches a pattern |
NOT | Displays a record if one or more conditions are NOT TRUE |
OR | TRUE if any of the conditions separated by OR is TRUE |
SOME | TRUE if any of the subquery values meet the condition |
JSON Operator
ChaosSearch supports a limited implementation of the json_value
operator. See Query JSON String Fields in SQL.
Updated 4 months ago