InfluxDB Clustered is currently only available to a limited group of InfluxData customers.
If interested in being part of the limited access group, please
contact the InfluxData Sales team.
SQL operators are reserved words or characters which perform certain operations,
including comparisons and arithmetic.
Arithmetic operators take two numeric values (either literals or variables) and perform a calculation that returns a single numeric value.
2 + 2
4 - 2
2 * 3
6 / 3
7 % 2
Comparison operators evaluate the relationship between the left and right operands and returns
123 = 123
|Not equal to|
123 <> 456
|Not equal to|
123 != 456
3 > 2
|Greater than or equal to|
3 >= 2
1 < 2
|Less than or equal to|
1 <= 2
|Matches a regular expression|
'abc' ~ 'a.*'
|Matches a regular expression (case-insensitive)|
'Abc' ~* 'A.*'
|Does not match a regular expression|
'abc' !~ 'd.*'
|Does not match a regular expression (case-insensitive)|
'Abc' !~* 'a.*'
Logical operators combine or manipulate conditions in a SQL query.
|Returns true if both operands are true. Otherwise, returns false.|
|Returns true if the left operand is within the range of the right operand.|
|Returns true if the results of a subquery are not empty.|
|Returns true if the left operand is in the right operand list.|
|Returns true if the left operand matches the right operand pattern string.|
|Negates the subsequent expression.|
|Returns true if any operand is true. Otherwise, returns false.|
Bitwise operators perform bitwise operations on bit patterns or binary numerals.
5 & 3
5 | 3
5 ^ 3
|Bitwise shift right|
5 >> 3
|Bitwise shift left|
5 << 3
SQL supports other miscellaneous operators that perform various operations.
'Hello' || ' world'
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community!
We welcome and encourage your feedback and bug reports for InfluxDB and this documentation.
To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.