MariaDB WHERE Clause

In MariaDB, WHERE clause is used with SELECT, INSERT, UPDATE and DELETE statement to select or change a specific location where we want to change.

It is appeared after the table name in a statement.

Syntax:

Note: WHERE clause is an optional clause. It can be used with AND, OR, AND & OR, LIKE operators.

WHERE Clause with Single Condition

Example:

We have a table "Students", having some data. Let's retrieve all records from "Student" table where student_id is less than 6.

Output:

WHERE Clause with AND Condition

It would return all columns from "Student" table where "student_name" is Ajeet AND "student_id" is greater than or equal to 1.

Both conditions must be satisfied.

Output:

WHERE Clause with OR Condition

It would return all columns from "Student" table where "student_name" is Ajeet OR "student_id" is greater than or equal to 1.

Anyone of the condition must be satisfied.

Output:

WHERE Clause with AND & OR Condition

It would return all columns from "Student" table where "student_name" is Ajeet AND "student_id" is greater than or equal to 1 OR student_address is Delhi.

Output: