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 |