How to get rows by counting

[pckidcomplainer]

Hi there!
I searched the forums but I didn´t find a real solution for my problem...I guess it´s a simple answer, so I say "SORRY!" from the beginning.

Ok, this is my table

date | userID

2001-12-01 | 1
2001-12-02 | 1
2001-12-03 | 1
2001-12-04 | 1
2001-12-01 | 2
2001-12-02 | 2
2001-12-03 | 2
2001-12-04 | 2
2001-12-01 | 3
2001-12-02 | 3
2001-12-03 | 3

What I want to achieve now, is that I want all the userID´s that exist FOUR times...an SQL-Statement I would like to see it work is something like this...

SELECT * FROM WHERE (COUNT(userID) = 4)

But that doesn´t work... :-(

Any ideas? That would be really nice...

Greetings...

[rulian]

$query="select *, count(userID) as usercount from WHERE";

then echo only those where usercount = 4 by means of a loop or what ever you please.

[[deleted]]

Or do this:

SELECT userid, count(userid) AS cnt
FROM table
GROUP BY userid
HAVING cnt = 4

[pckidcomplainer]

Very nice!
This works very well for me!
:-))