Subject Re: MySQL Enum type?
Author Adam
--- In, "kogerbnz" <kogerbnz@...> wrote:
> > I'll ask again: what are you trying to accomplish?
> I have a one-to-one relationship. In the "mastertable" I want to store
> a type about which other table to look up the additional fields. I
> want to store this type as one of the values from a text set.
> Hope you understand what I mean, but I think the workaround was
> already posted.

And that is a near perfect example of the dangers of an enum datatype.
Normalise your design properly, and this requirement 'goes away'.