Re: group by & order by rand() problem

[Alessandro Astarita]

Alle 21:57, giovedì 1 aprile 2004, Michael Stassen ha scritto:
> You could probably accomplish this with a variant of the MAX-CONCAT
> trick
> <http://www.mysql.com/doc/en/example-Maximum-column-group-row.html>.
> Something like:
>
>    SELECT user_id,
>           SUBSTRING(MAX(CONCAT(TRUNCATE(RAND(),4),title)),7) AS Title
>    FROM banners
>    GROUP BY user_id;

Thank you so much. This solution works correctly. 

-- 
Alessandro 'Asterix' Astarita <aleast@stripped>
CapriOnLine S.r.l. http://www.caprionline.com/
"Unix IS user friendly. It's just selective about who its friend are"