Chapter 8. SELECT Statement: The WHERE Clause
8.1 Introduction
In the WHERE clause, a condition is used to select rows from the intermediate result of the FROM clause. These selected rows form the intermediate result of the WHERE clause. The WHERE clause acts as a kind of filter that removes all the rows for which the condition is not true (but is false or unknown). This chapter describes the different conditions permitted in this clause.
Definition
<where clause> ::= WHERE <condition>
How is a WHERE clause processed? One by one, each row that appears in the intermediate result table of a FROM clause is evaluated, and the value of the condition ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
