count the number of times a field equals a specific value

[OniLink]

Hi,

Is it possible to count the number of times, for example, the field 'result' equals "won"?

Thanks for any help,
~Oni.

[cahva]

Do you mean...

SELECT COUNT(result) FROM table WHERE result = 'won';

[OniLink]

Yes that's it, but I need to do it for multiple values. So I need to count the number of times it equals 'lost' as well. Sorry, I should have indicated that in the beginning.

[Piranha]

SELECT COUNT(*), result FROM table GROUP BY result;