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?
Thanks for your help
>From: Mattias J <mjslask@stripped>
>To: "shaun thornburgh" <shaunthornburgh@stripped>, mysql@stripped
>Subject: Re: Can Mysql hold possible field values?
>Date: Mon, 17 Jan 2005 15:23:42 +0100
>At 2005-01-17 15:12, shaun thornburgh wrote:
>>I am attempting to create a database and have a query. Is it possible for
>>mysql to contain the possible field values in the database rather than
>>creating the options in the application?
>>For example Field_A can only be Yes or No, Field_B can be 50% or 80% etc.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql