Re: MYSQL-Search for duplicates

Works great with just a bit of modification. I actually needed to list all the duplicates, not just an example of each, so I just did a second query for all the records with those two identifiers. Thanks! J. Wharton "Lutz Brückner" <lb@lamuella.de> wrote in message news:m3r8kpytfr.fsf@linux.local... > 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 > > > joshwhar@cc.usu.edu (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