Use Select * from a Group by [your_field_name]
-----Original Message----- From: nullevent [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 9:43 AM To: [EMAIL PROTECTED] Subject: select unique records Hi mysql, i have table 'a' with one field 'name', which contains many dublicated records, like SELECT * FROM a; +-------+ | name | +-------+ | Peter | | Ivan | | Peter | | Peter | | Dima | | ... | +-------+ Now i want to see list of names (not repeated). How can i do it? Tnx, nullevent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]