UPDATE member
SET email='jeromey@aol.com',street='123 Elm St',city='Anytown',
state='NY',zip='01003'
WHERE last_name='York' AND first_name='Jerome';