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