I am trying to get this query to randomly pick a record from a table (trans) but it's not working:
SELECT ID FROM trans ORDER BY RAND() LIMIT 1; Can anyone let me know what I'm doing wrong and/or how to fix it. Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
