Quoting Richard Reina <[EMAIL PROTECTED]>: > 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 >
What error(s) is it giving you? Does it always return the same record? Is there more than one record in trans? I change the name of the table and tested it against mine and it works fine R. Whitney Transcend Development "Producing the next phase of your internet presence" http://xend.net Premium Quality Web Hosting http://xendhosting.com rw AT xend.net Net Binder http://netbinder.net 310-943-6498 602-288-5340 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]