MariaDB Comparison Operator
To test the equality and inequality, as well as other advanced comparing operations, MongoDB Comparison Operators are used. MariaDB supports the following comparison operators.
| OPERATOR | USES |
| = | equal |
| <=> | equal (safe to compare null values) |
| <> | not equal |
| != | not equal |
| > | greater than |
| >= | greater than or equal |
| < | less than |
| <= | less than or equal |
| IN ( ) | matches a value in a list |
| NOT | negates a condition |
| BETWEEN | within a range (inclusive) |
| IS NULL | null value |
| IS NOT NULL | non-null value |
| LIKE | pattern matching with |
| EXISTS | condition is met if subquery returns at least one row |