List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 17 1999 4:58pm
Subject:Re: question of values in group by
View as plain text  
On Thu, 1999-09-16 12:43:59 -0500, Mr. Anthony R.J. Ball wrote:
>   I have been wondering this for a while... Is there any way to get all
> the values of a specific field in a group by, for instance like a 
> join ',', @array in perl or something like that? No big deal... just 
> something I've wanted to be able to do int the past.

I've also been thinking about that, but I don't think it's possible on
the MySQL side.

For that, we would need something like a new aggregation function
GRPCONCAT(field, 'delimiter') for strings, comparable to SUM() for
numbers.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
question of values in group byMr. Anthony R.J. Ball16 Sep
  • Re: question of values in group byMartin Ramsch17 Sep