WHERE clause

The part of an SQL statement that specifies which rows to retrieve. The WHERE clause limits the scope of the query and specifies which columns are used to join multiple tables.