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:
Expand|Select|Wrap|Line Numbers
- SessionId Room1 Room2 Room3
- 1 0 1 0
- 2 1 0 1
Help will be much appreciated.
Thanks.