On 12/7/09 5:26 AM, "Victor Subervi" <victorsube...@gmail.com> wrote:
> 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? WHERE col LIKE '%val%' i didn't answer this before not because it is "challenging". on the contrary. i didn't answer because it is explained in the manual and on any number of easily found web pages. when you apparently don't make an effort to find the answer for yourself before you ask us, i don't feel much like making the effort to answer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
