Re: SELECT DISTINCT

[Nuno Pereira]

[EMAIL PROTECTED] wrote:

Depending on what version server you are running, the GROUP_CONCAT() 
function may be an option for you:

SELECT params, GROUP_CONCAT(ID)
FROM table
GROUP BY params;

I'm using 4.1.10a-standard-log Server version, and this is just what I 
wanted.

Thanks.
--
Nuno Pereira

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]