Selecting mysql field by logic expression

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";

How to fix this query?

I hope you know what I am trying to do from this query. it is difficult for me to describe them into sentences

Answer 1

SQL cannot do an UPDATE and a SELECT in the same query. Break it into two separate queries.

Answer 2

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

... and do the same with your other IFs