Hello list, I have a text field in a database, it contains a \r seperated list of items. I want a random item out of the list.
Please don't lead me down a path of using random in php or perl, that wont be happening on this one, I am looking for something more like.. Select name, random(split(data, "\r")) from something; -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
