Sorry...typo... SELECT DISTINCT * FROM a;
-----Original Message----- From: Angelo Sulbaran [mailto:[EMAIL PROTECTED] Sent: Friday, March 26, 2004 08:34 To: [EMAIL PROTECTED] Subject: RE: select unique records SELECT DISTINCTT * FROM a; -----Original Message----- From: nullevent [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 18:43 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
