WHERE Clause
Learn WHERE Clause (SELECT Queries, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction WHERE filters rows before they are grouped or returned. Each row is tested against a boolean condition; only rows for which the condition is TRUE survive (FALSE and NULL are dropped). It works with SELECT, UPDATE and DELETE alike.