mysql - 简单的 SQL 查询分类

Question

我想用获胜或失败的分类来填充获胜列，获胜定义为 1-3 名，失败定义为其他一切。

Answer 1

UPDATE table set win = 'lose' WHERE place NOT in (1,2,3);
UPDATE table set win = 'win' WHERE place in (1,2,3);

或者用一点 CASE 语句

UPDATE table set win =  CASE WHEN place IN (1,2,3) THEN 'win' 
                             WHEN place NOT IN (1,2,3) THEN 'lose' 
                        END ;