count of a value in a column in mysql database

Question

i have a large mysql database table in which one column contains values ranging from 1 to 9 what query can i give so that i can get the count of 1s and 2s and 3s ... 9s in that column in the database ?

rerun · Accepted Answer · 2010-03-04 05:55:26Z

3

select column, count(*) from table group by column

answered Mar 4, 2010 at 5:55

rerun

25.5k6 gold badges50 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Guffa · Accepted Answer · 2010-03-04 05:55:04Z

2

You use grouping:

select TheValue, count(*) from TheTable group by TheValue order by TheValue

answered Mar 4, 2010 at 5:55

Guffa

703k111 gold badges760 silver badges1k bronze badges

Collectives™ on Stack Overflow

count of a value in a column in mysql database

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related