select group_concat(NAME) as drivers from TABLE group by NAME; -- if you want to merge all the same concatanated values to one position: select group_concat(distinc NAME separator ',') as drivers from TABLE group by NAME;