> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
