Brian Dunning <[EMAIL PROTECTED]> wrote on 11/02/2005 09:12:39 PM: > On Nov 2, 2005, at 6:03 PM, Matt Babineau wrote: > > > It will do your whole table. Then give you 50 records. > > But there won't be any duplicates, right? It won't include the same > records more than once. I know that sounds stupid, just trying to > debug an odd problem. >
I am not sure there is any rule that says ORDER BY RAND() is uniquely ordered. http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html However, if your underlying query has unique rows then ordering those rows randomly should produce a randomized unique set...What is the problem you are trying to solve? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
