Thanks Matthias, Jay... I gave that a shot and got an error: mysql> select count(distinct email) from subscribes; ERROR 1064: You have an error in your SQL syntax near 'distinct email) from subscribes' at line 1
I have a feeling this has something to do with running 3.22 instead of 3.23. ;) Whadya think? -Chris -----Original Message----- From: Matthias Ragaz [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 10:32 AM To: Chris Blessing; [EMAIL PROTECTED] Subject: Re: general sql question > >select count(distinct(email)) from subscribes; > >But that's not legal. Any thoughts/ideas you all could send in would be >great. TIA! try: select count(distinct email) Sincerely Matthias Matthias Ragaz Informatik - Entwicklung Schweizerische Bibliothek für Blinde und Sehbehinderte Albisriederstasse 399 CH-8047 Zürich Schweiz Tel.: +41 1 491 25 55 Fax: +41 1 492 64 75 ------------------------------------------------------ --------------------------------------------------------------------- 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
