one query -- multiple counts

[zzz]

I have a table with feedback ratings

• positive
• neutral
• negative

Can I run one query and get a count on each response?

[bradgrafelman]

What's the table structure look like (i.e. how are the ratings stored)?

[dagon]

assuming one field called feedback with 3 potential values

SUM(IF(feedback = "Positive", 1,0)) AS Positive
, SUM(IF(feedback = "Negative", 1,0)) AS Negative
, SUM(IF(feedback = "neutral", 1,0)) AS neutral

[bradgrafelman]

Or just:

SELECT feedback, COUNT(*) FROM ratings GROUP BY feedback