RE: LIST function?

This will do it... SELECT id, group_concat(distinct buddy_id) FROM buddies GROUP BY id Ed -Original Message- Hi, When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from all the values in your specific group from the GROUP BY. Is there any function to simply

Re: LIST function?

At 14:44 +0100 4/20/04, Andy Hall wrote: Hi, When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from all the values in your specific group from the GROUP BY. Is there any function to simply return a list of the values in the group? GROUP_CONCAT()? Supported in MySQL

Re: LIST function

Never mind, I found the GROUP_CONCAT function but I am still using v. 3.23.37 so thats that. Looks like I'll be using PHP, unless anyone has a workaround of some kind? Thanks

LIST function?

Hi, When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from all the values in your specific group from the GROUP BY. Is there any function to simply return a list of the values in the group? e.g. SELECT id, LIST(buddy_id) FROM buddies GROUP BY id which would retur