MySql GROUP BY on script

[SimonIoa]

Hello i have a problem with a Sql script

SELECT col1_id, col1_name, col2 FROM table GROUP BY ?????

col1_id col1_name col2
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat
A john bear
A john dog
A john cat
A john bear
A john dog
A john cat
A john dog
A john cat

I want to return all results. It has to return like this: echo col1_id . col1_name (A john) and then col2 (bear,dog, cat)

[SimonIoa]

i don't want it to result echo col1_id . col1_name (A john,A john, Ajohn) and col2 (bear,dog, cat)

[urtrivedi]

You can use group_concat funtion

SELECT 
    col1_id,
    col1_name,

    GROUP_CONCAT(DISTINCT col2
        ORDER BY col2
        SEPARATOR ';')
FROM
    table

GROUP BY col1_id, col1_name

http://www.mysqltutorial.org/mysql-group_concat/

[SimonIoa]

Altough it shows the results on inspector response it doen't print them Why? I want to show the results on GROUP__CONCAT

[jamesdave]

Hey, is the question still relevant?