Re: SELECT unique possible?
| From: | Joao Prado Maia | Date: | Sat, 02 Sep 2000 01:04:54 +0000 |
| Subject: | Re: SELECT unique possible? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-14895@lists.php.net to get a copy of this message | ||
On Sat, 2 Sep 2000, Jonathan Chum wrote:
> In my PHP script, I'm trying to send an email to people. What I've
> done is a SELECT * FROM emails and then ran a while loop to email.
> Some folks have the same email so they get double emails. Is there
> mySQL way to select only unique address rather than the whole bit?
> Thanks
>
SELECT DISTINCT(email), * FROM emails
I guess that would work, I have a head-ache so bear with me.
Joao
--
Joao Prado Maia
Web Developer
Kefta.com, Inc