mysql> create table test(t enum('foo','bar')); Query OK, 0 rows affected (0.03 sec) mysql> describe test; +-------+-------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------------+------+-----+---------+-------+ | t | enum('foo','bar') | YES | | NULL | | +-------+-------------------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> INSERT INTO test(t) VALUES('gronk'); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from test; +------+ | t | +------+ | | +------+ 1 row in set (0.00 sec)