语法:update <table> set [column] = (case when [column1] {conditions} then {value} ....else {value} end) where {conditions}
update tmp_Matrix_X set type = (case when comments like 'newly%'
then 'add' when comments like 'Delete%' then 'delete' else
'published' end)