the think is that i need get binary set of column.
this was simplified example of it.
http://dev.mysql.com…t-datatype.html
i want get bin set of my column
mysql> SELECT rowid, myset, LPAD(BIN(myset+0),4,‘0’) AS binset FROM set_test;
the result is .
±------±----------------------------------±-------------+
| rowid | myset | binset |
±------±----------------------------------±-------------+
| 1 | Travel,Sports,Dancing | 0111 |
| 2 | Travel,Dancing | 0101 |
| 3 | Travel | 0001 |
| 4 | Dancing | 0100 |
| 5 | Dancing | 0100 |
| 6 | Sports,Dancing | 0110 |
| 7 | Travel,Sports,Dancing,Fine Dining | 1111 |
| 8 | Travel,Fine Dining | 1001 |
| 9 | Sports,Fine Dining | 1010 |
| 10 | Travel,Dancing,Fine Dining | 1101 |
±------±----------------------------------±-------------+
with my active record class.