this is a way to find dupes with sql

SELECT id, year, COUNT(*) AS cnt FROM table
GROUP BY id, year
HAVING cnt>1


[EMAIL PROTECTED] (J. Wharton) writes:

> Does anyone know of any built-in functions (either in PHP or MySQL) that can
> search for duplicates in a table according to 2 fields (id and year)?
> Thanks in advance,
> J. Wharton

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to