Re: Select distinct field won't return distinct value

I have a friend called GROUP_CONCAT, he may know what you want but he's only available since MySQL 4.1 2006/6/7, Blanton, Bob <BlantonB@mmcs.army.mil>:

It is a Sybase vendor function but I was wondering if mysql had something comparable. I don't see anything in the manual. Maybe the subquery is the only way to go. -----Original Message----- From: Chris [mailto:dmagick@gmail.com] Sent: Wednesday, June 07, 2006 8:50 AM To: Blanton, Bob Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Select distinct field won't return distinct value Blanton, Bob wrote: I'm just learning MySQL so don't know all the syntax. There is a "LIST" function in Sybase Adaptive Server Anywhere which would do that. Is there an equivalent function in MySQL? Query: SELECT distinct niin, list(serial_number) FROM fmds.maintenance_equipment group by niin order by niin Output:

niin          list(serial_number)
000213909     B71-11649,B71-11657,B71-11650
000473750     BAF-3750-0001,BAF-3750-0002,BAF-3750-0003
000929062     2341
001139768     2207

Pretty sure that's a sybase specific function. Nothing like that exists in mysql or postgresql. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php