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.

 

OPERATORUSES
=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
NOTnegates a condition
BETWEENwithin a range (inclusive)
IS NULLnull value
IS NOT NULLnon-null value
LIKEpattern matching with % and _
EXISTScondition is met if subquery returns at least one row

 

Content Protection by DMCA.com
Please Share