[RESOLVED] Enum?

[DigiRev]

For each user's account on my website, they can select multiple account types, ie: Artist, Musician, Director, etc...

What would be the appropriate value to use for this field in the MySQL database? ENUM?

Or can ENUM only be one value?

I'd rather not have to make another table just for the account types.

[kows]

an enum field can have multiple selections but only one value.

a set field can have multiple selections and multiple values.

what you want is the set field.

edit: keep in mind that when you insert values into a set field, they are comma delimited (ie. value1,value2,value3)

[CornedBee]

Make another table for the account types. It's more flexible if you ever need to change them.

[DigiRev]

Thanks, I may just use the SET field since the account types won't change that often. If they do then I'll probably consider making another table.

Thanks again to both of you. It says I have to spread the rep thing around before giving it to you again.