mysql GROUP_CONCAT with multiple columns

Question

I want to do a group concat with multiple columns inside it. This is the query I have(I want to know if it is possible, and if not, what other way can I do this?:

select  group.groupname, 
        group_concat(machine.machinename,'--',machine.machineModel) 
    inner join etc....

Rams · Accepted Answer · 2017-04-11 09:53:33Z

1

You need to first concatenate those values and then do group_concat.

select  group.groupname, 
        group_concat(machine.machinename||'--'||machine.machineModel)) 
    inner join etc....

edited Apr 11, 2017 at 9:53

answered Apr 11, 2017 at 9:46

Rams

2,1591 gold badge15 silver badges20 bronze badges

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

4 Comments

José Over a year ago

no such function: concat: select this is the error thar is giving me @Rams

José Over a year ago

this is mysqlite, I assume is the same as Mysql

Rams Over a year ago

I have change it to || symbol for concatenation of two values

José Over a year ago

Thanks :) great help!

Collectives™ on Stack Overflow

mysql GROUP_CONCAT with multiple columns

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related