OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Second Request: Challenging Select Statement

From: Victor Subervi (victorsubervigmail.com)
Date: Mon Dec 07 2009 - 04:26:25 CST

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 from information_schema.columns where
table_name='products' and column_name='Categories';

will give me the column and its enumerations. How do I supply one of the
enumerations from a column 'Categories' and get the ID?
TIA,
Victor