Database Guide : Database Help : Database windows and dialogs : SQL UPDATE statement : WHERE clause of UPDATE
WHERE clause of UPDATE
The WHERE clause of an UPDATE statement specifies a condition that restricts which rows are to be updated. Only the rows for which the condition is true will be updated.
The WHERE clause is optional. If it is not specified, all the rows in the table or view will be updated.
Last modified date: 01/29/2015