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

In this section