select distinct * from mytable is functioning just as it should what the
answer is not group by try pleas to explain better what do you want
almir
"Jared Howard" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I need to retrive all column information from
On Wed, 21 Mar 2001 11:04:48 -0700, Jared Howard ([EMAIL PROTECTED])
wrote:
>I need to retrive all column information from a DISTINCT query. But
>so
>far, I only can get one column to show by using this:
>
>SELECT DISTINCT my_column FROM my_table;
>
>which then gives me a list of my_column inform
I'm not sure what you're trying to do, but have you tried SELECT DISTINCT *
FROM tablename; ?
jack
-Original Message-
From: Jared Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 1:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL "DISTINCT" query
I
I need to retrive all column information from a DISTINCT query. But so
far, I only can get one column to show by using this:
SELECT DISTINCT my_column FROM my_table;
which then gives me a list of my_column information and is correct, but I
need all information from all columns. Querying this:
4 matches
Mail list logo
