Is it possible to concatenate multiple MySQL rows into one field?

Jeson84

select favorite_brands from consumers where consumer_id =1;

above query will return something like,

Coca Cola
Ford
Samsung

Is it possible to concatenate this result as follows?

Coca Cola, Ford, Samsung

DavidM

It is possible to use GROUP_CONCAT

First you have to set the data size of group contact according to your requirement. Default size is 1024 bytes.

set group_concat_max_len=2048

Then,

select consumer_id, group_concat(favorite_brands separator ', ')
from consumers group by consumer_id;