mysql query with if and else statement

Question

I need mysql query that will :

IF (result=win){SELECT dobitak} else if (result=half_win) {SELECT dobitak/2} else if (half_lost) {SELECT stake/2} else{0};
FROM matches 
WHERE id=$id

but i dont know whats the best solution to write query like this.

Possible duplicate: stackoverflow.com/questions/15683185/… — kimbarcelona
– kimbarcelona, Commented Apr 21, 2014 at 1:38

juergen d · Accepted Answer · 2014-04-21 01:34:38Z

3

select case when result ='win' then dobitak
            when result = 'half_win' then dobitak/2
            when result = 'half_lost' then stake/2
            else 0
       end as result
FROM matches 
WHERE id=$id

answered Apr 21, 2014 at 1:34

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2014-04-21 01:34:18Z

2

I think you can do what you want with a case statement:

select (case when result = win then dobitak
             when result = half_win then dobitak/2
             when half_lost then stake / 2
             else 0
        end)
from matches
where id = $id;

answered Apr 21, 2014 at 1:34

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Collectives™ on Stack Overflow

mysql query with if and else statement

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related