Syntax for multiple updates

[marty_arl]

i know how to update one part of a record at a time, example
UPDATE phone_list SET number='555-5555' where first_name='John';

what would be the syntax if i wanted to, oh, update his last name in the same command?

thanks in advance
marty

[[deleted]]

UPDATE phone_list
SET
number='555-5555',
lastname = 'Doe'
WHERE first_name='John';

Note: this also works if the field you want to update is also the field you are searching for:

UPDATE phone_list
SET
first_name = 'Foo',
last_name = 'Bar'
WHERE first_name='John';