Lee,
> I get the feeling there is a more efficient method using
> binary operations
> (only one field populated with zeros and ones) but I can't
> find anything to
> help in the manuals.
i think you should try to avoid such thing as much as you can.
Storing more than one piece of data in a column may bring up
a lot of problems if there is a need for changing structures
one day. It won't save you from having a criteria-explaining
table anyway.
As long as you don't want to store data for every hotel of
the world, a solution might be to store one record for
each criteria for each hotel:
hotel-id | criteria-id | value
---------------------------------------
rec1: | hotel1 | criteria1 | true
rec2: | hotel1 | criteria5 | false
Maybe there is no need for records having a false.
Regards,
TomH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
