I have a MySQL table where users have rated movies 1-5. I want to get a summary of how man 1,2,3,4 & 5's they have voted for.
I can get the answer for a single rating, below
SELECT COUNT(rating) AS "1 Star" FROM user_likes WHERE user_id=2 AND rating=1
Is it possible to get them all at in one go?