How to make multiple updates using a single query in MySQL
As you might know it’s quite easy to make multiple INSERTs in a single query, like this:
INSERT INTO mytable
(id, title)
VALUES
(‘1′, ‘Lord of the Rings’),
(‘2′, ‘Harry Potter’);
However, for some strange reason you can’t do multiple changes to a table in a single UPDATE query like this:
UPDATE mytable
SET (title=’Great Expectations’ WHERE id=’1′),
(title=’War and Peace’ WHERE id=’2′);