This blog has moved

I'm leaving these up to give myself some time to get the redirects together. Please visit the new blog at: blog.matasar.org

Ben Matasar

Fri, 16 Jun 2006

SQL for finding duplicate fields

I found this at Peter Freitag's blog.

SELECT email, COUNT(email) 
AS NumOccurrences FROM users 
GROUP BY email 
HAVING ( COUNT(email) > 1 );

tech | link | 2006/Jun

Ben Matasar ben@matasar.org