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

Jeson84Jeson84 USA
edited February 2014 in MySQL

select favorite_brands from consumers where consumer_id =1;

above query will return something like,

Coca Cola

Is it possible to concatenate this result as follows?

Coca Cola, Ford, Samsung


  • DavidMDavidM USA
    edited February 2014

    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


    select consumer_id, group_concat(favorite_brands separator ', ')
    from consumers group by consumer_id;
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion