Multiple COUNT() for multiple conditions in one query (MySQL)

Question

I have these queries :

SELECT COUNT(*) FROM t_table WHERE color = 'YELLOW'; SELECT COUNT(*) FROM t_table WHERE color = 'BLUE'; SELECT COUNT(*) FROM t_table WHERE color = 'RED'; 

Is there any way to get these results in one query?

Answer 1

SELECT color, COUNT(*) FROM t_table GROUP BY color 

Answer 2

If you want the result to be in one row you can use:

SELECT     SUM(IF(color = 'YELLOW', 1, 0)) AS YELLOW,     SUM(IF(color = 'BLUE', 1, 0)) AS BLUE,     SUM(IF(color = 'RED', 1, 0)) AS RED FROM t_table 

Working example