case when then else end

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

UPDATE quesgo_game_details SET user_choice = CASE question_idWHEN '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');