Mysql multiple row count?

Question

I have a database full of rows like

id,action,date
2,2,2010-03-01
3,2,2010-03-01
4,3,2010-03-01
5,3,2010-03-01
6,4,2010-02-01
7,4,2010-02-01

And I want to select all the count all the 2's and all the 3's and all the 4's. But I don't want to have to do 3 different SELECT COUNT() commands, is there a way to do this in a single command?

Note, I want to display this as something like

Action 2 = 2
Action 3 = 2
Action 4 = 2
(etc etc).

And I will also need to specific a date (so it only counts all the 2,3,4,etc for dates between 2010-02-03 and 2010-03-01 for example)

Stefan H · Accepted Answer · 2011-01-04 00:46:13Z

4

   SELECT action
        , Count(*)
     FROM Table
    WHERE date BETWEEN startDate AND EndDate
 GROUP BY Action

answered Jan 4, 2011 at 0:46

Stefan H

6,6934 gold badges26 silver badges35 bronze badges

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

Comments

slier · Accepted Answer · 2011-01-04 00:47:20Z

0

SELECT COUNT(*) FROM table GROUP BY action

answered Jan 4, 2011 at 0:47

slier

6,6566 gold badges41 silver badges58 bronze badges

Comments

svens · Accepted Answer · 2011-01-04 00:48:31Z

0

You can GROUP BY action your query. Also you could combine it with a WHERE id IN (2,3,4) to only get the rows for those ids.

answered Jan 4, 2011 at 0:48

svens

11.6k6 gold badges41 silver badges55 bronze badges

Comments

m1k3y3 · Accepted Answer · 2011-01-04 00:58:42Z

0

SELECT COUNT(*) as count FROM tableA GROUP BY columnA WHERE DATE BETWEEN dateFrom AND dateTO

answered Jan 4, 2011 at 0:58

m1k3y3

2,8088 gold badges41 silver badges68 bronze badges

Collectives™ on Stack Overflow

Mysql multiple row count?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related