Re: mySQL Question....
| From: | Don Read | Date: | Wed, 18 Apr 2001 06:12:44 +0000 |
| Subject: | Re: mySQL Question.... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49127@lists.php.net to get a copy of this message | ||
On 18-Apr-01 Jason Caldwell wrote:
> Opps. I meant GROUP BY... and it looks like I don't need to include the
> COUNT().
>
> SELECT email_addr, x GROUP BY email_addr HAVING x = 1;
>
> Is this the only way to display a listing without duplicates, or is there a
> more efficient (faster) way? I don't want to DELETE the duplicates, just
> don't want dups to show up in my SELECT queries.
>
> Thanks.
> Jason
>
>
select distinct(email_addr) ...
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.