Using WHERE With UPDATE and DELETE

In addition to the SELECT statement, the WHERE clause can also be used with UPDATE and DELETE statements. Examples of how to use the WHERE clause with these two commands can be seen in the UPDATE and DELETE sections.