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:[EMAIL PROTECTED] 
Sent: Wednesday, June 07, 2006 8:50 AM
To: Blanton, Bob
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
> 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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to