Challenging Select Statement

--001485354cc29ef0bb0479fe3f69
Content-Type: text/plain; charset=ISO-8859-1

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 column and its enumerations. How do I supply one of the
enumerations from a column 'Categories' and get the ID?
TIA,
Victor

--001485354cc29ef0bb0479fe3f69--