Query Operators
This page provides reference information for the query operators in TiDB Cloud Lake.
Operator Types
| Operator Type | Description |
|---|
| Arithmetic | Mathematical operations (+, -, *, /, %, DIV) |
| Comparison | Value comparisons (=, !=, <, >, <=, >=, BETWEEN, IN) |
| Logical | Boolean logic (AND, OR, NOT, XOR) |
| JSON | JSON data operations (::, ->, ->>, @>, <@) |
| Set | Combine query results (UNION, INTERSECT, EXCEPT) |
| Subquery | Nested queries (EXISTS, IN, ANY, ALL, SOME) |