List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:December 5 2009 5:06pm
Subject:Challenging Select Statement
View as plain text  
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?

Challenging Select StatementVictor Subervi5 Dec