mysql - 通过逻辑表达式选择mysql字段

Question

SELECT
    challenger_name as name,
    IF(challenger_timeout > challenged_timeout,
        (SET  wins + 1),
        NULL) as wins,
    IF(challenger_timeout < challenged_timeout,
        (SET  lose + 1),
        NULL) as lose,
    IF(challenger_timeout = challenged_timeout,
        (SET  draw + 1),
        NULL) as draw
FROM time_trial_challenge
GROUP by challenger_name ORDER by wins DESC";

如何修复这个查询？

我希望你知道我想从这个查询中做什么。我很难用句子来描述它们

Answer 1

SUM(IF(challenger_timeout > challenged_timeout,1,0)) as wins

...并对您的其他 IF 执行相同的操作