The WHERE clause is used in a SELECT statement with conditions to filter the result set. It is also used in the UPDATE and DELETE statement.
SELECT column_name1,column_name2,... FROM table_name WHERE conditions;
There can be one or many conditions and a condition must be evaluated to true or false.
A row must satisfy all conditions to be included in the result set.