The MySQL WHERE Clause
The WHERE
clause is used to filter records.
It is used to extract only those records that fulfill a specified condition.
WHERE Syntax
SELECT column1, column2, ... FROM table_name WHERE condition;
Note: The WHERE
clause is not only used in
statements, it is also used in
SELECTUPDATE
, DELETE
, etc.!