Mysql select count values from a single column

Question

A have a column named key - 1,1,2,2,2,2,3 Now i do it with 3 querys:

SELECT count(key) as k FROM `test` WHERE key=1
SELECT count(key) as k FROM `test` WHERE key=2
SELECT count(key) as k FROM `test` WHERE key=3

How to count in one query how many 1,2,3?

Does this answer your question? [Count the occurrences of DISTINCT values](https://stackoverflow.com/questions/1346345/count-the-occurrences-of-distinct-values) — mickmackusa, Apr 20 '21 at 09:32

score 10 · Accepted Answer · answered Aug 25 '13 at 08:03

10

Use group by:

SELECT `key`, COUNT(*) FROM `test` GROUP BY `key`;

answered Aug 25 '13 at 08:03

fabien

score 1 · Answer 2 · answered Aug 25 '13 at 07:56

1

you can do like this

select count(key) as K FROM test where key in (1,2,3)

answered Aug 25 '13 at 07:56

Aman Varshney

score 1 · Answer 3 · answered May 26 '17 at 13:52

1

This is another option:

SELECT sum(key=1) as k1, sum(key=2) as k2,sum(key=3) as k3 FROM `test`

you could also add a group by column if the values of key were part of some other group.

answered May 26 '17 at 13:52

Boice

score 0 · Answer 4 · answered Aug 25 '13 at 08:07

0

Try this

SELECT  COUNT(Key) as K
        FROM 
        test 
        GROUP BY Key

answered Aug 25 '13 at 08:07

commit

4 Answers4