List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:April 11 2005 12:51pm
Subject:results in random order.
View as plain text  
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 
Thread
results in random order.Richard Reina11 Apr
  • Re: results in random order.Richard Whitney11 Apr