mysql - 如何在表中为所有具有相同名称的记录设置相同的列ID号

Question

如何通过一次梅赛德斯查询设置相同的数字“优先级”。

+---------------------+-------------+-------------+|        cars         |    place    |   priority  |+---------------------+-------------+-------------+|Aston Martin         |Moscov       |1            ||Mercedes Benz        |Paris        |3            ||Aston Martin         |Moscov       |1            ||Ferrari Testarossa   |New York     |2            ||Ferrari Testarossa   |Moscov       |2            ||Subaru impreza       |Paris        |4            ||Aston Martin         |Paris        |1            ||Aston Martin         |New York     |1            ||Mercedes Benz        |Moscov       |3            ||Subaru impreza       |New York     |4            |+---------------------+-------------+-------------+

Answer 1

UPDATE table_name
SET priority = 1
WHERE cars = 'Mercedes Benz'