CodesJava

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.

 

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

 

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status