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 <[EMAIL PROTECTED]> CapriOnLine S.r.l. http://www.caprionline.com/ "Unix IS user friendly. It's just selective about who its friend are" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
