Hi,

I want to query the table below as to return the titles of the column where the intersection of SessionId and Roomx is 0.The type of the Room is TINYINT - which in mysql represents BOOLEAN

Below is the table:

Code:
SessionId    Room1    Room2    Room3
        1          0        1        0  
        2          1        0        1
For the above table for example for SessionId...