#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    1
    Rep Power
    0

    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.
  2. #2
  3. Did you steal it?
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,007
    Rep Power
    9398
    I think you're asking about ENUMs. It's a different data type - not a VARCHAR.
    Code:
    ENUM("string 1", "string 2", "string 3")

IMN logo majestic logo threadwatch logo seochat tools logo