Using the where clause with update

The where clause specifies which rows are to be updated. For example, if the author Heather McBadden changes her name to Heather MacBadden:

update authors
set au_lname = "MacBadden"
where au_lname = "McBadden"
and au_fname = "Heather"