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
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 r
OTECTED]
> 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;
>
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 cont
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,