Concatenate Last column Query Result if id match

Question

I am getting this result by using select query.

But what actually i want the result is for example:

| 23407 | 42 M-65 Giant jacket, Brandit | Size:L - colour:Olive   |
| 23417 | 42 M-65 Giant jacket, Brandit | Size:2XL - colour:Olive |
| 23413 | 42 M-65 Giant jacket, Brandit | Size:XL - colour:Black  |

Possible duplicate of [Can I concatenate multiple MySQL rows into one field?](http://stackoverflow.com/questions/276927/can-i-concatenate-multiple-mysql-rows-into-one-field) — DarkSquirrel42, Jan 11 '17 at 09:47
Please refer following link to achieve your result [Concatenate many rows into a single text string](http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string) thanks! — Ramesh, Jan 11 '17 at 09:57

score 0 · Accepted Answer · answered Jan 11 '17 at 09:48

0

You probably want to use GROUP_CONCAT() of that att_name column group by the id_product column like

select *, GROUP_CONCAT(att_name) as att_name
from 
  ( 
      // your posted query as subquery 
  ) xxx
group by id_product

answered Jan 11 '17 at 09:48

Rahul

76,197
13
71
125

thank you so much rahul this is what i am looking for - thanks again buddy – Arsalan Jan 11 '17 at 10:15
@Arsalan, consider accepting the answer then by clicking the check button – Rahul Jan 11 '17 at 10:16
rahul would you clear one thing that what is 'xxx' for ? – Arsalan Jan 11 '17 at 10:25
@Arsalan, that's the alias for inline subquery else it would result in syntax error – Rahul Jan 11 '17 at 10:26
what i want now is for example: "product_attribute_id | id_product | name - att_name" – Arsalan Jan 11 '17 at 10:31
@Arsalan, Ok but post a separate question for that. – Rahul Jan 11 '17 at 10:32
why separate rahul? – Arsalan Jan 11 '17 at 10:43

Concatenate Last column Query Result if id match

1 Answers1