the bits in MySQL in the same
order as your SET declaration, you can use
Reverse(Binary(Bin(Bit_Or(column_name
which will give you 1011.
Awesome. That's just the ticket.
Thank you very much again,
chas
-
Before posting
represents a number, that there would be some bitwise
operation that would painlessly produce all the members
of the SET that appear at least once.
If not, no worries - I'll redo the database properly
when I get some time.
Thanks again,
chas
Bob wrote:
Sir, the basic problem is that you've
not very
scalable.
Is there a method to retrieve a list of all the values
that have been used at least once ?
Thank you very much,
chas
ps. using an old version at the moment - 3.22.25
-
Before posting, please check:
http