mySQL Question....
| From: | Jason Caldwell | Date: | Wed, 18 Apr 2001 05:47:07 +0000 |
| Subject: | mySQL Question.... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49123@lists.php.net to get a copy of this message | ||
if i perform a SELECT query (say) like the following:
SELECT email_addr FROM myTable WHERE x = 1
in this query i want to pull-out (or list) all email addresses where x
equals 1, however, suppose i don't want any duplicate email addresses...
would i use ORDER BY and COUNT(*) to get listing of non-duplicate email
addresses, and just ignore the COUNT() ?
Thanks.