MySQL Where

March 31, 20191 min readUpdated 1/19/2021

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.