[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.
Chris
More information about the thelist
mailing list