A admin Administrator Staff member Aug 20, 2008 #1 Hi, Say I have the following field : fruit ENUM ("Apple", "Cherry") Is there a way to know that index 1 = Apple? If i do : SELECT fruit FROM table WHERE fruit=1 It gives me "Apple" only if I have a row with Apple in it, nothing otherwise. Thanks.
Hi, Say I have the following field : fruit ENUM ("Apple", "Cherry") Is there a way to know that index 1 = Apple? If i do : SELECT fruit FROM table WHERE fruit=1 It gives me "Apple" only if I have a row with Apple in it, nothing otherwise. Thanks.
