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
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;
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
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,