select favorite_brands from consumers where consumer_id =1;
above query will return something like,
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.
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!