Re: mySQL Question....
| From: | Toby Miller | Date: | Wed, 18 Apr 2001 18:30:51 +0000 |
| Subject: | Re: mySQL Question.... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49243@lists.php.net to get a copy of this message | ||
How about actually using distinct?
SELECT DISTINCT(email_addr) FROM myTable WHERE x = 1
--Toby
----- Original Message -----
From: "Jason Caldwell" <jason@thinkingman.org>
To: <php-general@lists.php.net>
Sent: Wednesday, April 18, 2001 1:47 AM
Subject: [PHP] mySQL Question....
> 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.
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net