[thelist] SQL help please

CDitty mail at redhotsweeps.com
Sun Dec 24 19:35:26 CST 2000

Hello all.   I hope all is well on Xmas eve.

I am trying to get a count of all the unique email addresses in my 
database.  For some reason, my sql statement only returns the total 
count.  I know this should be a simple one, but I didn't see anything in my 
books.  Here is my sql.

select distinct count(emailaddr) from scratch_log where gameid = '1' and 
playedwhen like '12242000%'

Thanks and a merry xmas/happy holiday.


More information about the thelist mailing list