Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
Comparison Operators and Functions
The following comparison operators and functions are supported.
Name |
Description |
---|---|
|
Check if a value is within a range |
|
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 |
|
Check whether a value is in a comma-separated list of values |
|
Check whether a value is not in a comma-separated list of values |
|
Compare a value to a boolean |
|
Compare a value to the complement of a boolean |
|
Check if a value is NULL |
|
Check if a value is not NULL |
|
Test whether the argument is NULL |
|
Check if a value matches a simple pattern |
|
Check if a value does not match a simple pattern |
|
Not equal operator |
|
Compare two strings and return -1, 0, or 1 |
In this section
Last modified: April 24, 2021