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
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: