Following is a list of conditions which are used in MariaDB with CRUD operation. Conditions are generally used with SELECT statement.
Index |
Conditions |
Explanation |
1) |
AND Condition |
It is used when 2 or more conditions to be met. |
2) |
OR Condition |
It is used when any one of the conditions are met. |
3) |
AND & OR |
It is used when AND & OR both conditions are met. |
4) |
LIKE Condition |
Use simple pattern matching (wildcards) in a where clause. |
5) |
RLIKE Condition |
Use regular expression matching in a where clause |
6) |
IN Condition |
It is used as an alternative to multiple OR conditions |
7) |
NOT condition |
It is used to negate a condition |
8) |
IS NULL condition |
It is used ti test for a null value. |
9) |
IS NOT NULL Condition |
It is used to test for a not null value. |
10) |
BETWEEN Condition |
It is used to retrieve within a range (inclusive). |
11) |
EXISTS Condition |
It is used specify if condition is met then subquery returns at least one row. |