The WHERE keyword filters a result set to include only records that fulfill a specified condition or set of conditions.

The following selects all fields from the Customers table where the country is USA OR Canada.