SQL Operators

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
`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

ChaosSearch supports a limited implementation of the json_value operator. See Query JSON String Fields in SQL.