Easy learning with example program codes

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 (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


Please follow and like us:

Copyright © 2020 CodesJava Protection Status