> -----Original Message----- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: maandag 14 augustus 2006 4:54 > To: Mark > Cc: mysql@lists.mysql.com > Subject: Re: Random SELECT on subset
Hmm, this still does not do what I want: SELECT columnId FROM queue WHERE processed = '1' ORDER BY RAND() LIMIT 4" Thanks to you, the query has been greatly simplified, but the result is still the same: every once in a while (like if I run this twenty times in a row), I only get 3 items returned, or even 2! I'm guessing the RAND() function occassionally rounds the number to a columnId (bigint) that does not match the subset of the WHERE clause? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]