How to concat/append multiple returned rows into only one row?

Question

I have query which returns this result:

+-----------------------------------------+
| product_english                         |
+-----------------------------------------+
| can of orange juice                     |
| oatmeal container                       |
| milk bottle 28 oz                       |
| chocolate powder no sugar added - 16 oz |
| instant coffee 8 oz container           |
| almonds bag 25 oz.                      |
+-----------------------------------------+

it would return 6 rows in total as you can see.

I would like to return all records in only one row. Is that possible?

Here is the query to visualize things better:

SELECT product_english
FROM menuBreakfast mb
JOIN productPerMenu ppm ON ppm.menu_id = mb.breakfast_id
JOIN productList pL on ppm.product_id = pL.product_id
WHERE breakfast_id = 'B1';

Thanks in advance.

Answer 1

SELECT GROUP_CONCAT(product_english ', ')
FROM menuBreakfast  
WHERE breakfast_id = 'B1';

Also you can apply concat

SELECT concat(product_english ) as product_english FROM menuBreakfast  
WHERE breakfast_id = 'B1';