The WHERE clause defines the criteria to limit the records affected by the SELECT, UPDATE, and DELETE statements.

The general form of the WHERE clause is as follows: