mysql as if 多个,mysql as多个if语句
1 2 3 | IF(condition, value_if_true, value_if_false) SELECT IF(500<1000, 5, 10) as reyo; SELECT IF(STRCMP( "hello" , "bye" ) = 0, "YES" , "NO" ) as reyo; |
1 2 3 4 5 6 7 8 9 10 11 | SELECT visitor AS school, home AS temp , vl.leagueid AS vleague, hl.leagueid AS hleague, CASE WHEN vl.leagueid = hl.leagueid THEN '1' WHEN ((vl.leagueid = 26 AND hl.leagueid = 27) OR (vl.leagueid = 27 AND hl.leagueid = 26)) THEN '1' ELSE 0 END AS sms.reyo.cn FROM u96nk_rvball_schedule LEFT JOIN u96nk_rvball_schools AS vl ON vl.id = visitor LEFT JOIN u96nk_rvball_schools AS hl ON hl.id = home WHERE gamedate between '2013-01-01' AND '2013-12-31' |
1 2 3 4 5 6 7 8 9 10 | SELECT visitor AS school, home AS temp , vl.leagueid AS vleague, hl.leagueid AS hleague, CASE WHEN school = 50 AND temp = 2 THEN '1' WHEN school = 51 AND temp = 3 THEN '2' ELSE 0 END AS leaguematch FROM ...... |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 分享4款.NET开源、免费、实用的商城系统
· Obsidian + DeepSeek:免费 AI 助力你的知识管理,让你的笔记飞起来!
· 解决跨域问题的这6种方案,真香!
· Windows 提权-UAC 绕过
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2010-01-05 使用JS+WebBrowser解决Web打印问题(完成事件)