define 'enum' and 'set' columns in mysql with same values

Question

is there a way to define an column of type 'enum' and then define another column in the same table of type 'set' with the same values of the 'enum' ?

for example we have an 'enum' with values "one", "two", "three", we define the first column in the table with that enum type. Then I need to define the second column in the table with the 'SET' of "one", "two" and "three".

I hope I made myself clear on that...

Answer 1

You could rather do something like:

CREATE TABLE foo(bar VARCHAR(10),
                 CHECK(bar IN ('value1', 'value2'))
                );