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
SELECT *
FROM equipement
WHERE class = microphones
GROUP BY type;
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
Sorry, I wasn't thinking... you actually want to do something like this:
select type, max(id) as id, max(staff_member) as staff_member, max(class) as class,
max(manufacturer) as manufacturer, max(model) as model,
max(description) as description, max(picture) as picture, max(created) as created,
if you are storing a bunch of T/F, you can store 8 of them into a single
byte... each bit position will represent one question...
you just have to do some BIT manipulation on your end...
andy wrote:
Hi there,
I am searching for the best way to store true or false inside a MySQL DB.
With