WHERE clause is used to select or change a specific location to fetch the records from a table. It is used with SELECT, INSERT, UPDATE and DELETE statement.

Syntax:

[COMMAND] field,field2,... FROM table_name,table_name2,... WHERE [CONDITION]