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 ...... |
· Obsidian + DeepSeek:免费 AI 助力你的知识管理,让你的笔记飞起来!
· 分享4款.NET开源、免费、实用的商城系统
· 解决跨域问题的这6种方案,真香!
· 5. Nginx 负载均衡配置案例(附有详细截图说明++)
· Windows 提权-UAC 绕过
2010-01-05 使用JS+WebBrowser解决Web打印问题(完成事件)