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
