Used with a SELECT statement to specify search criteria for retrieving rows of data from a table or group of tables. The syntax is:
WHERE search-condition;
The WHERE clause can also be used with DELETE and UPDATE. For example:
WHERE city = "Columbia" OR "Annapolis";
will cause all records that have a city of Columbia or Annapolis to be pulled from the table and exported into the desired target file.