duplicate records check

[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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]