Philippe, If he is pre-4 (I assume that as he does not seem to have the GROUP_CONCAT() function) and UDFs aren't available until 5+, how exactly would he do this as a UDF? :-D
Paul, I believe you are going to have to combine those fields during some form of post-query processing (macro, script, program, etc). Sorry! Shawn Green Database Administrator Unimin Corporation - Spruce Pine Philippe Poelvoorde <[EMAIL PROTECTED]> wrote on 08/12/2004 05:20:49 AM: > Egor Egorov wrote: > > > "Paul McNeil" <[EMAIL PROTECTED]> wrote: > > > > > >>If I am not running 4, is there another way to achieve the same result as > >>GROUP_CONCAT(myField) > >>? > > > > > > I don't think so. :( > > Except if you are ready to make a User-defined function to make a simple > group_concat... > http://dev.mysql.com/doc/mysql/en/UDF_aggr._calling.html > > -- > Philippe Poelvoorde > COS Trading Ltd. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >