I have a table that looks like this:
CREATE TABLE inventory (
inventoryid int(11) NOT NULL,
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
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.