Javatpoint Logo
Javatpoint Logo

MariaDB Conditions

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.





Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA