Re: Second Request: Challenging Select Statement

2009-12-07 Thread Victor Subervi
On Mon, Dec 7, 2009 at 8:08 AM, Tom Worster wrote: > On 12/7/09 5:26 AM, "Victor Subervi" wrote: > > > Hi; > > I posted this Saturday. Perhaps it's too challenging for those who read > it > > to answer. I hope someone can. > > > > I need to write a select statement that enables me to select colu

Re: Second Request: Challenging Select Statement

2009-12-07 Thread Tom Worster
On 12/7/09 5:26 AM, "Victor Subervi" wrote: > Hi; > I posted this Saturday. Perhaps it's too challenging for those who read it > to answer. I hope someone can. > > I need to write a select statement that enables me to select column 'ID' > from a table where a certain value is found in an enum of

Second Request: Challenging Select Statement

2009-12-07 Thread Victor Subervi
Hi; I posted this Saturday. Perhaps it's too challenging for those who read it to answer. I hope someone can. I need to write a select statement that enables me to select column 'ID' from a table where a certain value is found in an enum of a specific column. For example... select column_type fro

Challenging Select Statement

2009-12-05 Thread Victor Subervi
Hi; I need to write a select statement that enables me to select column 'ID' from a table where a certain value is found in an enum of a specific column. For example... select column_type from information_schema.columns where table_name='products' and column_name='Categories'; will give me the co