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]
