Date: 03/31/06 (MySQL Communtiy)    Keywords: no keywords

I have a table that I know has some entries that shouldn't be there. There should only be one entry per story number. I want to run a query to find out which ones are in there twice. The structure is:

TableName: StorySeries
Columns: StoryID (this should be unique), SeriesID, StoryNumber

I do know how to fix it so there won't be future entries with the same StoryID, but I dont know how to find the ones that are currently in there.

Thanks in advance for your help!

Source: http://community.livejournal.com/mysql/91322.html