The MySQL SET Datatype

Mike Hillyer

One of the least commonly used of the MySQL datatypes has to be the SET datatype. The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strings specified during table creation. The SET datatype is similar to the ENUM datatype in that they both work with predefined sets of strings, but where the ENUM datatype restricts you to a single member of the set of predefined strings, the SET datatype allows you to store any of the values together, from none to all of them.

In his article at http://www.vbmysql.com/articles/mysql/the-mysql-set-datatype/
Mike Hillyer shows, how you can use SET datatype.