Select title,case Emergency when 1 then '紧急' else '普通' End as emergency from already_sign
select a.title,if(a.Emergency=1,'紧急','普通')emergency from already_sign a
select a.title,if(a.Emergency=1,'紧急','普通')emergency from already_sign a