MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE data
SELECT 123 id, 5 stat UNION ALL
SELECT 234 id, 5 stat UNION ALL
SELECT 321 id, 5 stat UNION ALL
SELECT 432 id, 5 stat UNION ALL
SELECT 333 id, 5 stat UNION ALL
SELECT 789 id, 5 stat UNION ALL
SELECT 555 id, 5 stat ;
SELECT * FROM data;

Records: 7  Duplicates: 0  Warnings: 0




id
stat


123
5

234
5

321
5

432
5

333
5

789
5

555
5


WITH `cte` AS (
    SELECT 123 `id`, 1 `stat` UNION ALL
    SELECT 321     , 2        UNION ALL
 -- ...
    SELECT 456     , 8        UNION ALL
    SELECT 789     , 9
)
UPDATE `data`
JOIN   `cte` USING ( `id` )
SET `data`.`stat` = `cte`.`stat`;

Rows matched: 3  Changed: 3  Warnings: 0


SELECT * FROM data;


id
stat


123
1

234
5

321
2

432
5

333
5

789
9

555
5