代码示例
UPDATE categories
SET display_order = CASE id
WHEN 1 THEN 3
WHEN 2 THEN 4
WHEN 3 THEN 5
END,
title = CASE id
WHEN 1 THEN 'New Title 1'
WHEN 2 THEN 'New Title 2'
WHEN 3 THEN 'New Title 3'
END
WHERE id IN (1,2,3)
自己的实际使用(需要是同一张表中的数据修改后进行跟新到最后一列)
UPDATE wm
SET class = CASE WHEN med_list_codg like 'X%' THEN '西药'
WHEN med_list_codg like 'Z%' THEN '中药'
WHEN med_list_codg like 'Z%' THEN '西药'
else '重要药物'
end;