finding ENUM values

[Anon]

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.