The comparison operators include: !=, <, <=, <=>, >=, >, etc...
| Title | Description |
|---|---|
| != | Not equal operator. |
| < | Less than operator. |
| <= | Less than or equal operator. |
| <=> | NULL-safe equal operator. |
| = | Equal operator. |
| > | Greater than operator. |
| >= | Greater than or equal operator. |
| BETWEEN AND | True if expression between two values. |
| COALESCE | Returns the first non-NULL parameter |
| GREATEST | Returns the largest argument. |
| IN | True if expression equals any of the values in the list |
| INTERVAL | Index of the argument that is less than the first argument |
| IS | Tests whether a boolean is TRUE, FALSE, or UNKNOWN |
| IS NOT | Tests whether a boolean value is not TRUE, FALSE, or UNKNOWN |
| IS NOT NULL | Tests whether a value is not NULL |
| IS NULL | Tests whether a value is NULL |
| ISNULL | Checks if an expression is NULL |
| LEAST | Returns the smallest argument. |
| NOT BETWEEN | Same as NOT (expr BETWEEN min AND max) |
| NOT IN | Same as NOT (expr IN (value,...)) |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/comparison-operators/