[SOLVED] COUNT

[esport]

Hi Guys,

I was wonder  how to acheive multiple COUNTS in 1 query. For example, I have a user_rating table,

 

id, user_id, rating

 

i want to count the different ratings, say A and B for example. Can I do this in 1 query?

 

Thanks

Daniel

[fenway]

You can, but you have to cheat with SUM:

 

sum( if( rating = 'A', 1, 0 ) ) as ratingA,

sum( if( rating = 'B', 1, 0 ) ) as ratingB,

[esport]

Thanks heaps, worked a treat. So is that the only way to achieve this? Otherwise do multiple queries with COUNT and WHERE clause.