2 messages in com.mysql.lists.mysqlRe: LIST, ARRAY, CONCAT aggregate fu...
FromSent OnAttachments
dm...@mrc-dunn.cam.ac.uk04 Aug 2002 13:05 
Dan Bolser05 Aug 2002 08:12 
Subject:Re: LIST, ARRAY, CONCAT aggregate function?
From:Dan Bolser (dm@mrc-dunn.cam.ac.uk)
Date:08/05/2002 08:12:07 AM
List:com.mysql.lists.mysql

Should I post this to the dev list?

For a particular enum field I would like a list of values for a particular ID all in one field.

For example

SELECT LIST(enum_field) FROM table_name GROUP BY ID; ^^^^^ ? - Any such function?

Comma separated would be great.

Anyone know how I would begin writing a UDF to do this?

Anyone already done this?

Thanks, Dan.

P.S. MYSQL, QUERY, SQL, DUMB FILTER, HUMANS MOCK YOU, THIS IS SPAM

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail
<mysql-unsubscribe-dmb=mrc-@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php