Append multiple columns to one string

Question

I am searching for the best way to do that: I have table with columns ID, network1, network2....30. the value in the column is true or false. I want to get string with network numbers for all row when the value is true.

like this:

"5,7,8"

when the values in network5 and network7 and network8 are true and the others is false.

can you please advise?

Or rather a normalisation (store id - network pairs in their own record) — Shadow
– Shadow, Commented Jun 7, 2016 at 10:30

sagi · Accepted Answer · 2016-06-07 10:19:11Z

2

You can try using multiple IF's combined with CONCAT()

SELECT t.id,
       concat(IF(t.network1 = 'TRUE','1,',''),
              IF(t.network2 = 'TRUE','2,',''),
              IF(t.network3 = 'TRUE','3,',''),
              IF(t.network4 = 'TRUE','4,',''),
              .....
FROM YourTable t

answered Jun 7, 2016 at 10:19

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Append multiple columns to one string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related