mysql case when

select case
when sex='0' then 'man'
when sex='1' then 'woman'
else 'just so so ' end
from user;


select case sex
when '0' then 'man'
when '1' then 'woman'
else 'just so so ' end
from user;

posted @   小小小尘埃  阅读(477)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示