I have 2 tables: users and user_params

An example users table:

id | name 1 | Vasya Pupkin 2 | Pupok Vaskin

Sample user_params table

 uid | param_int 1 | 10 1 | 20 1 | 30 2 | 10 2 | 25

How do I select the data so that the end result looks like this?

 id| name | params 1 | Vasya Pupkin | 10,20,30 2 | Pupok Vaskin | 10,25

    1 answer 1

     SELECT users.id, users.name, GROUP_CONCAT( user_params.param_int ORDER BY user_params.param_int ASC SEPARATOR ',') AS params FROM users LEFT JOIN user_params ON users.id = user_params.uid GROUP BY users.id;
    • one
      Fine! That is necessary, thanks! I basically suspected that this was somehow done through functions like concat, but I did not hear about group_concat. Thank you very much! - Jeid 1:16 pm