"-- creating normalized set, copy values from settable create table normalset (id int not null default 0, val char (8), key (id)); insert into normalset SELECT id, 'cyan' FROM settable WHERE s like '% cyan%'; insert into normalset SELECT id, 'yellow' FROM settable WHERE s like '% yellow%'; insert into normalset SELECT id, 'magenta' FROM settable WHERE s like '% magenta%'; insert into normalset SELECT id, 'black' FROM settable WHERE s like '% black%';"