0
+----+-------+----+----+----+----+----+----+
| id | name  | 10 | 20 | 30 | 40 | 50 | 60 |
+----+-------+----+----+----+----+----+----+
|  0 | party |  0 |  7 | 82 |  0 |  8 |  0 |
|  1 | party |  9 |  0 |  0 |  3 |  0 | 17 |
+----+-------+----+----+----+----+----+----+

I need to know what columns have value on some id. How to get column names, where column have value(value>0) on some id?

For example, for id = 1 i want to get 10, 40, 60

Lexxy
  • 457
  • 2
  • 11

0 Answers0