2012
07.27

Wrote this today and thought it might be useful for someone else. It compares the table against itself and tells you if there are any values are identical.

Here’s the SQL:

SELECT *
FROM tablename tn 
WHERE (
   SELECT COUNT(*)  FROM tablename tn2
   WHERE tn2.`fieldname` = tn.`fieldname`
) >= 2

No Comment.

Add Your Comment