Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


MySQL HeatWave User Guide  /  ...  /  Comparison Functions and Operators

2.11.4 Comparison Functions and Operators

The following table shows supported comparison functions and operators. The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. See Section 2.7.1, “Encoding String Columns”.

Table 2.4 Comparison Functions and Operators

Name VARLEN Support Description
BETWEEN ... AND ... Yes Check whether a value is within a range of values
COALESCE() Yes Return the first non-NULL argument. Not supported as a JOIN predicate.
= Yes Equal operator
<=> NULL-safe equal to operator
> Yes Greater than operator
>= Yes Greater than or equal operator
GREATEST() Yes Return the largest argument. Temporal types are supported from MySQL 8.0.30 with the exception of the YEAR type.
IN() Yes Check whether a value is within a set of values.

expr IN (value,...) comparisons where the expression is a single value and compared values are constants of the same data type and encoding are optimized for performance. For example, the following IN() comparison is optimized:

SELECT * FROM Customers WHERE Country IN ('Germany', 'France', 'Spain');
IS Test a value against a boolean
IS NOT Test a value against a boolean
IS NOT NULL Yes NOT NULL value test
IS NULL Yes NULL value test
ISNULL() Test whether the argument is NULL
LEAST() Yes Return the smallest argument. Temporal types are supported from MySQL 8.0.30 with the exception of the YEAR type.
< Yes Less than operator
<= Yes Less than or equal operator
LIKE Yes Simple pattern matching
NOT BETWEEN ... AND ... Yes Check whether a value is not within a range of values
!=, <> Yes Not equal operator
NOT IN() Yes Check whether a value is not within a set of values
NOT LIKE Yes Negation of simple pattern matching
STRCMP() Yes Compare two strings.