第一种写法
select CASE WHEN checkResult=1 THEN '正在审核'
when checkResult=2 THEN '审核通过'when checkResult=10 THEN '被举报'
ELSE 'more' END
as result,squarefilm.* from squarefilm
第二种写法
select CASE checkResult WHEN 1 THEN '正在审核'when 2 THEN '审核通过'
when 10 THEN '被举报'
ELSE 'more' END
as result,squarefilm.* from squarefilm
select if(checkResult=1,"正在审核",if(checkResult=2,'审核通过','被举报')) as result from squarefilm