Another option is to have another table with the item name and number using that as a lookup table.
IMHO it all depends on the data if the select is static (or rarely changes) an enum would be best. If is changes a lot then I would use another table to store it in. -Michael "I protectssss you, skin brother." -mriswith On Sun, 6 Jul 2003, Todd O'Bryan wrote: > I'm new, too, so someone correct me if I'm wrong, but... > > if you make it an ENUM field in a table you can store it using the > value in the selection, retrieve it as the same value, and still get > all the advantages of numeric storage. > > Todd > > On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote: > > > Hello list, > > I'm really new to mysql and databases in general. I have a select form > > that contains a very long list of options, and what I want to do is > > store the selected item as a number instead of the items name in order > > to speed up searches. My problem comes when a search is done and I > > can't > > figure out how to return the query with the items name not the number. > > Any suggestions and help is greatly appreciated. > > > > Dan Cox > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]