The SET type stores a list of values.
A SET is a string object that can have zero or more values.
In a SET type, you can choose more than one option to store.
A SET type can contain up to 64 items.
Each of which must be chosen from a list of values.
Multiple set members are separated by commas (',').
SET member values should not contain commas.
mysql> mysql> mysql> CREATE Table Test( -> Advertiser SET('A','B','C') -> ); Query OK, 0 rows affected (0.03 sec) mysql> mysql> mysql> INSERT INTO Test (Advertiser) values('A, B'); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> mysql> mysql> drop table Test; Query OK, 0 rows affected (0.02 sec) mysql>