WHERE Clause of UPDATE

The WHERE clause lets you specify search criteria to limit the rows to be updated. If you omit the WHERE clause, every row in the table is updated. For more information, see the WHERE clause of SELECT.