mysql更新表带条件

update table set column = case column/columnB 

when 1 then 2

when 2 then 3

else 4

end;