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
mysql中的decode等价实现 【转】
最新推荐文章于 2024-01-27 12:13:55 发布
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