查询
(case when c.material_type=0 then 0
when c.material_type=0 then 1 when c.material_type=2 then 5 else 0 end) as process_status
更新
UPDATE pur_pr_item_work SET process_status=
CASE WHEN MATERIAL_TYPE='1' THEN 1 WHEN MATERIAL_TYPE='2' THEN 5 END
WHERE PR_FORM_NO=10208