Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Victor Subervi (victorsubervigmail.com)
Date: Mon Dec 07 2009 - 04:26:25 CST
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.
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?