SQL Operators

A summary of the SQL operator support in ChaosSearch

SQL Arithmetic 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. 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%';`
`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

Updated over 1 year ago