How does GROUP_CONCAT work?

Question

MySQL

Let's say there are 2 tables:
users

pets

I make a query:

select users.id_user,users.name, GROUP_CONCAT(pets.pet SEPARATOR ', ') AS pets FROM users LEFT JOIN pets ON users.id_user=pets.id_user;

And I get this rubbish:

Answer 1

This function works together with grouping, you have the wrong request.
See documentation: https://dev.mysql.com/doc/refman/5.0/en/group-by-f...
UPD: maybe this answer on SO will help you: stackoverflow.com/questions/4455958/mysql-group -co...