Re: How to find random records in a subset?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Jun 3, 2005, at 6:48 AM, Marek Kilimajer wrote:

Brian Dunning wrote:

I am using a routine to find 50 random records in a large MySQL database (about a million records) where I generate a list of 50 random unique ID's,


why can't you use the where condition in the above query?

Because I wouldn't get all 50 records that I need - I'd only get the few out of the 50 that happened to be in the needed subset.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux