mysql update multiple update in one query

Question

MySQL

Hello, I apologize in advance if this question seems childish to someone.

It is required to update 5 records in the same table in different rows.
Ie SET filed=1 where id=1, SET filed=2 where id=12, SET filed='0.5' where id=3…

Described as best I could. I would really appreciate it if you point me in the right direction

Answer 1

Your solution is slow. It is more efficient to update 1 field per 1 normal request, without joins.
Or use this option, it's much more efficient than yours:
UPDATE `table` SET `field` = CASE `id`
WHEN val1 THEN data1
WHEN val2 THEN data2
ELSE `field` END
Just be sure not to forget ELSE.

Answer 2

you can also do this
INSERT INTO `table` (id, field) VALUES (1, 1), (2, 12), (3, 0.5) ON DUPLICATE KEY UPDATE field = VALUES(field)