Use 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"