select case

最新推荐文章于 2025-07-23 17:36:50 发布

tanggongde

最新推荐文章于 2025-07-23 17:36:50 发布

阅读量886

点赞数

CC 4.0 BY-SA版权

文章标签： join null

本文链接：https://blog.youkuaiyun.com/tanggongde/article/details/1393401

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