sql语句问题UPDATE select SET `status` = CASE WHEN

Question

问题相关代码，请勿粘贴截图

UPDATE select SET status = CASE WHEN select_id = '24' THEN '3' WHEN select_id = '25' THEN '1' ELSE status END WHERE select_id IN ('24','25')

运行结果及报错内容

Answer 1

UPDATE select SET status = (CASE select_id  WHEN  '24' THEN '3' WHEN '25' THEN '1' ELSE status END) WHERE select_id IN ('24','25')