I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned not null
I'm trying to find the number of distinct ipAddresses associated with a particular id over a specified time frame -- for simplicity, let's say the time frame is the last 60 minutes. So, I use the following query: SELECT DISTINCT ipAddress FROM table WHERE initDate >= DATE_ADD(now(), INTERVAL -60 MINUTE) AND id = [whatever id I'm looking for...]; This works and returns a result set with one row per distinct ipAddress. In my program, I can count the number of rows in the result set to get my answer. My question is this: is there any way to modify this query so it returns a *count* of the number of distinct ipAddresses, rather than having a row for each distinct ipAddress in the result set? Can I use some sort of aggregate function like COUNT() when also specifying DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
