CREATE TABLE t3 (v1 ENUM('red', 'green', 'blue'), v2 SET('a', 'b', 'c')) ENGINE=Aria;
INSERT INTO t3 (v1, v2) VALUES ('red', 'a,b'), ('green', 'c'), ('blue', 'a,c');
REPAIR TABLE t3 QUICK EXTENDED USE_FRM;
SELECT * FROM t3 WHERE v1 = 'red' AND v2 LIKE '%a%';