UPDATE person SET state = 'NY' WHERE city = 'New York';