DROP TABLE IF EXISTS items;
CREATE TABLE items (
name VARCHAR(255),
colors SET("black",
"dim gray",
"dark gray",
"gray",
"light gray",
"gainsboro",
"white smoke",
"white",
"red",
"orange red",
"dark orange",
"orange",
"gold",
"yellow",
"chartreuse",
"lawn green"),
INDEX (colors)
) DEFAULT CHARSET=utf8;
SHOW CREATE TABLE items;
Table	Create Table
items	CREATE TABLE `items` (
  `name` varchar(255) DEFAULT NULL,
  `colors` set('black','dim gray','dark gray','gray','light gray','gainsboro','white smoke','white','red','orange red','dark orange','orange','gold','yellow','chartreuse','lawn green') DEFAULT NULL,
  KEY `colors` (`colors`)
) ENGINE=mroonga DEFAULT CHARSET=utf8
INSERT INTO items VALUES ("t-shart", "black,gray");
INSERT INTO items VALUES ("hat", "white,dark gray");
INSERT INTO items VALUES ("parka", "chartreuse,orange");
SELECT * FROM items;
name	colors
t-shart	black,gray
hat	dark gray,white
parka	orange,chartreuse
SELECT * FROM items WHERE colors = "dark gray,white";
name	colors
hat	dark gray,white
DROP TABLE items;
