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 ......

 

posted @   锐洋智能  阅读(202)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· Obsidian + DeepSeek:免费 AI 助力你的知识管理,让你的笔记飞起来!
· 分享4款.NET开源、免费、实用的商城系统
· 解决跨域问题的这6种方案,真香!
· 5. Nginx 负载均衡配置案例(附有详细截图说明++)
· Windows 提权-UAC 绕过
历史上的今天:
2010-01-05 使用JS+WebBrowser解决Web打印问题(完成事件)
点击右上角即可分享
微信分享提示