select case status when 1 then '成功' when 2 then '失败' else '其他' end from user case后面紧跟要被作为判断的字段when后面跟判断条件then后面跟结果else相当于defaultend是语句结束语