Check out DISTINCT. Respectfully, Ligaya Turmelle
""Clive Luk"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]