SELECT DISTINCT ... Renish wrote:
Gurus,How do I go about to selecting an item which is repeated more than one in a field in a table.For example Item table Mango Orange Carrot Papaya Mango Mango
-- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]