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 records, like
SELECT * F
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
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 recor
