Selecting Descreption Field from multible row

Question

MySql Database

I am not sure if i could do this . I have a table with values as below

  |invoicenumber|item_descreption| 
  |      1      |     boots      |
  |      1      |     hats       |

I need to make select statment to return only one value from the above tables the expected result should be

  | allItemsInTheInvoice |
  |  boots , hats        |

Can someone help me to do that ?

what's your RDBMS? MySQL and sql-server are different. – D-Shih Nov 22 '21 at 12:53 — D-Shih, Nov 22 '21 at 12:53
@D-Shih the database is mysql – Ahmed Shahin Nov 22 '21 at 12:54 — Ahmed Shahin, Nov 22 '21 at 12:54
What's the expected result if you add the row (2, 'socks')? – jarlh Nov 22 '21 at 12:59 — jarlh, Nov 22 '21 at 12:59

score 1 · Answer 1 · answered Nov 22 '21 at 12:56

1

You can try to use GROUP_CONCAT

Query 1:

SELECT GROUP_CONCAT(item_descreption) as allItemsInTheInvoice
FROM T

| allItemsInTheInvoice |
|----------------------|
|           boots,hats |

if you want to select invoicenumber need to add in group by

SELECT GROUP_CONCAT(item_descreption) as allItemsInTheInvoice ,invoicenumber
FROM T 
GROUP BY invoicenumber

answered Nov 22 '21 at 12:56

D-Shih

I guess _allItemsInTheInvoice_ means that OP wants to GROUP BY invoicenumber. – jarlh Nov 22 '21 at 13:00
Next time please double check if a question has already been answered here on SO in case a question is such a straightforward one! – Shadow Nov 22 '21 at 13:03

1 Answers1