Query help needed - mysql 3.23.58 linux 1

[thedaver]

I have this query working:

SELECT ip,count(ip) as count FROM banips WHERE date BETWEEN (CURDATE() - INTERVAL 1 DAY) AND CURDATE() group by ip order by count asc;

I am having a great of trouble adding the condition

"where count > 5"

I receive error "ERROR 1054: Unknown column 'count' in 'where clause'"

I'm wondering if its possible to make such a criteria apply for a value derived from count(ip)

Thanks.

D.E.R. Management - IT Project Management Consulting

http://www.dermanagement.com/

 

[hoinz]

Shouldn't it be:
having count > 5
?

 

[thedaver]

Yup! This worked

SELECT ip,count(ip) as count FROM banips WHERE date BETWEEN (CURDATE() - INTERVAL 1 DAY) AND CURDATE() group by ip having count > 5 order by count asc;

D.E.R. Management - IT Project Management Consulting

http://www.dermanagement.com/

 

[hoinz]

glad it helped,
thanks