Hi Neil, 1) You could ask for the count of each listed item in a column.
something like: SELECT item, count(item) from parts GROUP BY item; 2) you could then use SELECT id,item from parts WHERE item = 'xxx'; to review the double entries. This is just a general sample, perhaps if you give more details than we can be more specific. ;-) Best regards Nils Valentin Tokyo/Japan 2003年 7月 9日 水曜日 15:42、Neil Tompkins さんは書きました: > Could any one advise what SQL statement I would need to use, to check a > table for any duplicate records e.g that contain the same data within a > field. Note that I haven't got the field as a unqiue field. > > Thanks > Neil > > _________________________________________________________________ > Stay in touch with absent friends - get MSN Messenger > http://www.msn.co.uk/messenger -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
