Get column names according to condition

Nayana Adassuriya · #1 (**permalink**) 11-24-09, 12:00

Hi all

i have a table as fallow in my mysql 5 database

Id | R | G | B
---------------
12 | 0 | 1 | 1
14 | 1 | 0 | 0
18 | 0 | 1 | 0
19 | 0 | 1 | 0

I want to get the column names that having value 1 where id = 12
the result should be 'G' and 'B'
So how can i write the query
Plz help soon

thanks
Nayana Adassuriya

gvee · #2 (**permalink**) 11-24-09, 12:17

Code:

SELECT CASE WHEN R = 1 THEN 'R' END
     + CASE WHEN G = 1 THEN 'G' END
     + CASE WHEN B = 1 THEN 'B' END
FROM   your_table
WHERE  id = 12

r937 · #3 (**permalink**) 11-24-09, 15:03

george, fer cryin out pete's sake, you can't add strings

what were you thinking

gvee · #4 (**permalink**) 11-25-09, 08:33

Concat() ?

Internet Services

Web Development

Digital Marketing

Consumer Tech