note 39823 deleted from function.mysql-query by cece
| From: | cece@php.net | Date: | Sun, 14 Nov 2004 13:18:13 +0000 |
| Subject: | note 39823 deleted from function.mysql-query by cece | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-80498@lists.php.net to get a copy of this message | ||
Note Submitter: Johann Eckert
----
To find double entries in a table:
SELECT db1.*
FROM tbl_data db1, tbl_data k2
WHERE db1.id <> db2.id
AND db1.name = db2.name
db1.id must be the PK
db1.name must be the fields that should be verified as double entries.
(I'm not sure wether the code is correct but in my case it works)
Johann