Date: 12/17/05 (MySQL Communtiy)    Keywords: no keywords

how can i return all rows that have duplicate data in a particular field? in other words, if i have a table


id | f_name | l_name
1  | bob    | smith
2  | bob    | johnson
3  | tim    | richards
4  | jen    | richards
5  | ben    | orchard
6  | jen    | popple


and i'm interested in duplicate first names, i'd want my query to return rows 1,2,4, and 6. any suggestions on how to do that?

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