For supported functions and operators, refer to Section 2.12, “Supported Functions and Operators”.
-
Column-to-column filters, excluding the
<=>
filter.Before MySQL 8.3.0, both columns must be
VARLEN
encoded and column-to-column filters must use columns that are encoded with the same character set and collation. -
Column-to-constant filters, excluding the
<=>
filter.Before MySQL 8.3.0, the character set and collation of the constant variable must match the character set and collation of the constant.