SingleStore DB

Comparison Operators and Functions

The following comparison operators and functions are supported.

Name

Description

BETWEEN ... AND ...

Check if a value is within a range

NOT BETWEEN ... AND ...

Check if a value is not within a range

=

Equal operator

<=>

NULL-safe equal operator

>

Greater than operator

>=

Greater than or equal operator

<

Less than operator

<=

Less than or equal operator

IN()

Check whether a value is in a comma-separated list of values

NOT IN()

Check whether a value is not in a comma-separated list of values

IS

Compare a value to a boolean

IS NOT

Compare a value to the complement of a boolean

IS NULL

Check if a value is NULL

IS NOT NULL

Check if a value is not NULL

ISNULL()

Test whether the argument is NULL

LIKE

Check if a value matches a simple pattern

NOT LIKE

Check if a value does not match a simple pattern

!=, <>

Not equal operator

strcmp()

Compare two strings and return -1, 0, or 1