Comparison Operator in MariaDB

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.


= 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 % and _
EXISTS condition is met if subquery returns at least one row


Please Share