mysql GROUP_CONCAT duplicates

Solution 1:

You need to use the DISTINCT option:

GROUP_CONCAT(DISTINCT animal)