数据库条件语句

 --update machinepath
select machinepath ,pcpath,filename from table1 where node2 = 'aaa'
update table1 set machinepath =
(
case 
when filename like '%语文%' then '语文/nn学'
when filename like '%数学%' then '数学/nn学'
when filename like '%英语%' then '英语/nn学'
when filename like '%物理%' then '物理/nn学'
when filename like '%化学%' then '化学/nn学'
when filename like '%生物%' then '生物/nn学'
when filename like '%政治%' then '政治/nn学'
when filename like '%历史%' then '历史/nn学'
when filename like '%地理%' then '地理/nn学'
end
)
where node2 = 'aaa'