Taggin system?

[kejo]

hello guys,

i have a list of soccer players:
i want to add tags to these names, that will describe players' roles (GK, defender(left,right,center), midfielder(left,right,center), forwards(left,right,center) ).

how do you think i should implement this? what kind of variables (in mysql)?
NOTE: a player can even have multiple roles.

hope you can help.
thanks in advance.

[Phill Pafford]

I would suggest the SET variable (http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html) type