case when then else end

1、批量更新多个条件多个值

UPDATE quesgo_game_details 
    SET user_choice = CASE question_id
        WHEN '100_243944' THEN 'A'
        WHEN '100_446929' THEN 'B'
        WHEN '100_568287' THEN 'C'
				else '什么也没有选'
    END
WHERE question_id IN ('100_243944','100_446929','100_568287','100_444003','100_433531');