Re: Can Mysql hold possible field values?

[Jigal van Hemert]

> Thanks for your replies, i have also found SET which appears to do the
same
> thing, is there a reason why everyone suggested ENUM as opposed to SET?

ENUM is a type that has many alternative values for one single property:
e.g. eye colour is one of these alternatives: brown, green, blue, grey.

SET is a type that hold many different properties which can either be
switched on or off;
e.g. sports available are: soccer, tennis, basketball, track. Member has
selected: soccer and track, so the field contains: 'soccer,track'.

Regards, Jigal.