[eluser]Bigil Michael[/eluser]
I would like to select the columns which have value 1.
table
id user_id demo1 demo2 demo3 demo4 demo5 demo6 ....................................................
1 15 1 0 0 1 0 1 ......................................
2 18 0 0 1 0 0 1 ..........................................
i want the output like this.
for user_id 15 : demo1 demo4 demo6
'' 18 : demo3 demo6
Can any one help me??
thanks in advance.....