October 18th, 2012, 11:11 AM
How to do this on varchar or text field
Hello Dear forum members and programmers, I am trying to port a MS Access DB to Mysql, found a tool and did it, anyway, in Access I could do something like this :
Text = "string 1", "string2", "string3"
Text field with a set of ready strings, and at the table it was like drop down choise, anyway I can do this on MySQL?
Thank you for your time,
Thanks in advance.
October 18th, 2012, 02:25 PM
I think you're asking about ENUMs. It's a different data type - not a VARCHAR.
ENUM("string 1", "string 2", "string 3")