mysql case when 中可以使用and

(case when com_orders.is_review =0 then \'未评审\' when com_orders.is_review is NULL and com_orders.type=2 then \'未评审\' when com_orders.is_review=1 and com_reviews.review=0 then \'评审已接收\' when com_orders.is_review=1 and com_reviews.review=1 then \'评审已接收\' when com_orders.is_review=1 and com_reviews.review=2 then \'评审未接收\' when com_orders.is_review=2 then \'评审中\' else null end) as list_status

记录一篇，示例如上。