Comparison - Influxdb

Comparison operators evaluate the relationship between the left and right operands and returns true or false.

Operator	Meaning
`=`	Equal to	{{< icon "link" >}}
`<>`	Not equal to	{{< icon "link" >}}
`!=`	Not equal to	{{< icon "link" >}}
`>`	Greater than	{{< icon "link" >}}
`>=`	Greater than or equal to	{{< icon "link" >}}
`<`	Less than	{{< icon "link" >}}
`<=`	Less than or equal to	{{< icon "link" >}}
`IS DISTINCT FROM`	Is distinct from	{{< icon "link" >}}
`IS NOT DISTINCT FROM`	Is not distinct from	{{< icon "link" >}}
`~`	Matches a regular expression	{{< icon "link" >}}
`~*`	Matches a regular expression (case-insensitive)	{{< icon "link" >}}
`!~`	Does not match a regular expression	{{< icon "link" >}}
`!~*`	Does not match a regular expression (case-insensitive)	{{< icon "link" >}}

= {#equal-to .monospace}

The = operator compares the left and right operands and, if equal, returns true. Otherwise returns false.

sql

SELECT 123 = 123

Int64(123) = Int64(123)
true

!=, <> {#not-equal-to .monospace}

The != and <> operators compare the left and right operands and, if not equal, returns true. Otherwise returns false.

sql

SELECT 123 != 456

Int64(123) != Int64(456)
true

sql

SELECT 123 <> 456

Int64(123) != Int64(456)
true

> {#greater-than .monospace}

The > operator compares the left and right operands and, if the left operand is greater than the right operand, returns true. Otherwise returns false.

sql

SELECT 3 > 2

Int64(3) > Int64(2)
true

>= {#greater-than-or-equal .monospace}

The >= operator compares the left and right operands and, if the left operand is greater than or equal to the right operand, returns true. Otherwise returns false.

sql

SELECT 3 >= 2

Int64(3) >= Int64(2)
true

< {#less-than .monospace}

The < operator compares the left and right operands and, if the left operand is less than the right operand, returns true. Otherwise returns false.

sql

SELECT 1 < 2

Int641(1) < Int64(2)
true

<= {#less-than-or-equal .monospace}

The <= operator compares the left and right operands and, if the left operand is less than or equal to the right operand, returns true. Otherwise returns false.

sql

SELECT 1 <= 2

Int641(1) <= Int64(2)
true

IS DISTINCT FROM {.monospace}

The IS DISTINCT FROM operator is a NULL-safe operator that returns true if both operands are not equal; otherwise, it returns false. This operator guarantees the result of a comparison is true or false and not an empty set.

sql

SELECT 0 IS DISTINCT FROM NULL

Int64(0) IS DISTINCT FROM NULL
true

IS NOT DISTINCT FROM {.monospace}

The IS NOT DISTINCT FROM operator is a NULL-safe operator that returns true if both operands are equal or NULL; otherwise, it returns false. This operator negates IS DISTINCT FROM.

sql

SELECT NULL IS NOT DISTINCT FROM NULL

NULL IS NOT DISTINCT FROM NULL
true

~ {#regexp-match .monospace}

The ~ operator compares the left string operand to the right regular expression operand and, if it matches (case-sensitive), returns true. Otherwise returns false.

sql

SELECT 'abc' ~ 'a.*'

Utf8("abc") ~ Utf8("a.*")
true

~* {#regexp-match-case-insensitive .monospace}

The ~* operator compares the left string operand to the right regular expression operand and, if it matches (case-insensitive), returns true. Otherwise returns false.

sql

SELECT 'Abc' ~* 'A.*'

Utf8("Abc") ~* Utf8("A.*")
true

!~ {#regexp-nomatch .monospace}

The !~ operator compares the left string operand to the right regular expression operand and, if it does not match (case-sensitive), returns true. Otherwise returns false.

sql

SELECT 'abc' !~ 'd.*'

Utf8("abc") !~ Utf8("d.*")
true

!~* {#regexp-nomatch-case-insensitive .monospace}

The !~* operator compares the left string operand to the right regular expression operand and, if it does not match (case-insensitive), returns true. Otherwise returns false.

sql

SELECT 'Abc' !~* 'a.*'

Utf8("Abc") !~* Utf8("a.*")
false