有点忘了，记录下
case colume
when condition then result
when condition then result
when condition then result
else result
endcase
when condition then result
when condition then result
when condition then result
else result
end原文：https://www.cnblogs.com/jichi/p/11972929.html