select case

来源:互联网 发布:好玩的软件 编辑:程序博客网 时间:2024/05/01 20:56

select match.*,(case when chipset='0' then '甲赢' else '乙赢' end)as chipset,(case when result is null then '未知'  when result=0 then '甲赢' else '乙赢' end)as gameresult,(stake.chip+stake.costs) as money from match left join stake on(match.matchid=stake.matchid) where stake.userid=$this->userid order by match.matchid desc

原创粉丝点击