time grouping in mysql

2001-11-03 Thread Greg Sarsons
I haven't succeeded in being able to group by time. My timestamp field is -mm-dd hh:mm:ss. What I would like is have a query that will enable me to be to group on events say every 5 minutes. I've played around with using time_to_sec(timestamp) to convert all the times to seconds and then gr

help with a query

2001-11-02 Thread Greg Sarsons
All be the first to admit that I'm new with mysql. I'm looking for some guidance on putting a query together. What I have a database created by snort which is an IDS. The database information of all the packets that crossed a network segment. For example IP src address, IP destination address,