Re: non-unique records
| From: | bill | Date: | Mon, 11 Feb 2002 22:06:55 +0000 |
| Subject: | Re: non-unique records | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16830@lists.php.net to get a copy of this message | ||
Hmmm, so ...
SELECT COUNT(myfield) AS mycount
FROM mytable
WHERE mycount > 1
would work?
Rick Emery wrote:
> SELECT COUNT(myfield) AS mycount FROM mytable;
>
> If mycount > 1, then the field value is not unique
>
> -----Original Message-----
> From: bill [mailto:bill@billtron.com]
> Sent: Monday, February 11, 2002 3:49 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] non-unique records
>
> How can I find records that do -not- have a unique value in a field?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php