RE: [PHP-DB] non-unique records
| From: | Rick Emery | Date: | Mon, 11 Feb 2002 22:02:12 +0000 |
| Subject: | RE: [PHP-DB] non-unique records | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16829@lists.php.net to get a copy of this message | ||
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