Conditions in MariaDB

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

 

CONDITION USES
AND When 2 or more conditions to be met.
OR When any one of the conditions are met.
AND & OR When AND & OR both conditions are met.
LIKE Simple pattern matching (wildcards) in a where clause.
RLIKE Regular expression matching in a where clause
IN As an alternative to multiple OR conditions
NOT To negate a condition
IS NULL To test for a null value.
IS NOT NULL To test for a not null value.
BETWEEN To retrieve within a range (inclusive).
EXISTS To specify if condition is met then subquery returns at least one row.

 

Please Share