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 similar to
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
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;
yet
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 a mysql table named
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,* FROM equipement WHERE class
