Hi people,

I'm going rather mad trying to understand the SET type column, which would appear to be just what I want, on the surface.

After I have created a SET column with 10 entries, 0,1,2,3,4,5,6,7,8,9 I want to SELECT records using a BINARY notation (it talks about a binary feature in the MySQL manual).

So I figured that this:

SELECT set_col, set_col+0 WHERE set_col & 5

would return records where the 1st and 3rd elements were set, i.e. 101 (binary 5) but it just isn't reliable!!! Putting in & 1 did select all records with the first element set, &2 got all second elements, but &3 did not get only those the have elements 1 and 2 set.

Who's got this one cracked out there?