oops, i accidentally sent it without finishing...
anyway, what i wanted to say was DISTINCT, at least how i learned it, was
working with rows instead of colums:
http://www.mysql.com/doc/en/DISTINCT_optimisation.html
is there a reason why you dont want to list the columns?
russ arbuthnot wrote:
you maybe using it the wrong way. read the doc:
russ arbuthnot wrote:
> I have a mysql table named "equipment" with 11 columns named: id,
> staff_member, class, type, manufacturer, model, description, picture,
> created, modified, and published.
>
> I'm trying to write a select statement simil
x, may or not be the correct function to use depending
on what your need is.
<>< Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Monday, August 12, 2002 12:22 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] select distinct with all columns
SELECT DISTINCT type,* FRO
SELECT DISTINCT type,* FROM equipement WHERE class = "microphones";
<>< Ryan
-Original Message-
From: russ arbuthnot [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] select distinct with all columns
I have
I have a mysql table named "equipment" with 11 columns named: id,
staff_member, class, type, manufacturer, model, description, picture,
created, modified, and published.
I'm trying to write a select statement similar to this:
SELECT DISTINCT type FROM equipement WHERE class = "microphones";
y