RE: DBI Count Distict

2003-06-27 Thread FARRINGTON, RYAN
Title: RE: DBI Count Distict I would use the SQL server to make the counts for me... or you could take the query then make a hash using the first three digits as the key and make the value increment... then you just hash through the hash (hehehe) and get your final count... -Original

RE: DBI Count Distict

2003-06-27 Thread Tobias Hoellrich
Try: select left(Data,3) as start, count(*) as occurances from table group by start; Hope this helps Tobias PS: Tried this on mysql ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of steve silvers Sent: Friday, June 27, 2003 7:52 AM To: