Conditions in MariaDB

Conditions in MariaDB are generally used with SELECT statement, with CRUD operations. Below is the list of conditions supported in MariaDB.

 

CONDITIONUSES
ANDWhen 2 or more conditions to be met.
ORWhen any one of the conditions are met.
AND & ORWhen AND & OR both conditions are met.
LIKESimple pattern matching (wildcards) in a where clause.
RLIKERegular expression matching in a where clause
INAs an alternative to multiple OR conditions
NOTTo negate a condition
IS NULLTo test for a null value.
IS NOT NULLTo test for a not null value.
BETWEENTo retrieve within a range (inclusive).
EXISTSTo specify if condition is met then subquery returns at least one row.

 

Content Protection by DMCA.com
Please Share