更新滿足條件的所有行

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