List:General Discussion« Previous MessageNext Message »
From:Yoed Anis Date:March 23 2004 5:58pm
Subject:Selecting a Column
View as plain text  
Hi,

I have a table that looks like this:
CREATE TABLE inventory (
inventoryid int(11) NOT NULL,
sunday int(3),
monday int(3),
tuesday int(3),
wednesday int(3),
thursday int(3),
friday int(3),
saturday int(3),
PRIMARY KEY (inventoryid)
);

And I'm trying to run a command like 

SELECT DAYNAME('2004-03-23') FROM inventoryRoom WHERE inventoryid='1';

That doesn't return "Tuesday", but the value in the column Tuesday, an
int of value 10.

I need something like
SELECT COLUMN(DAYNAME('2004-03-23')) FROM inventoryRoom WHERE
inventoryid='1';

But I don't know what command I'm looking for and all my searchs have
come up fruitless.
Plz CC this to my address if you reply.

Thanks,
Yoed 

Thread
Selecting a ColumnYoed Anis23 Mar
  • Re: Selecting a ColumnLigaya Turmelle24 Mar
    • RE: Selecting a Columntweewan.wong24 Mar
      • RE: Selecting a ColumnChris24 Mar