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.

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA