Hi,

this is a way to find dupes with sql

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

Lutz


[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