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 |
---|---|
| TRUE if all of the subquery values meet the condition |
| TRUE if all the conditions separated by AND are TRUE |
| TRUE if any of the subquery values meet the condition |
| TRUE if the operand is within the range of comparisons |
| TRUE if the subquery returns one or more records |
| TRUE if the operand is equal to one in a list of expressions |
| TRUE if the operand matches a pattern. The LIKE pattern is case sensitive, and the pattern supports two symbols for matching:
Typically LIKE is used as a condition in
|
| Displays a record if one or more conditions are NOT TRUE |
| TRUE if any of the conditions separated by OR is TRUE |
| TRUE if any of the subquery values meet the condition |
Updated 13 days ago