Hi,

I have this table 'main'

id    name    courseA    courseB    courseC
1     Anna    yes        no         yes
2     Mary    no         yes        yes
3     John    yes        no         no
4     Robb    yes        yes        yes

So, I want to get column names if the search meets my requirement. Example: Get me the column name of those courses which Anna joined.

So it will get the result the column name for name=Anna AND 'column name'=yes

Expected result:

courseA courseC

Anyone?