On 06-Jul-01 Roger Ramirez wrote:
> I have a database of 5.6 million records and I need to choose 5000 random
> records. What would that query look like?
>
SELECT foo from bar ORDER BY RAND() LIMIT 5000
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's alw
> I have a database of 5.6 million records and I need to choose 5000 random
> records. What would that query look like?
select * from records order by rand() limit 5000;
destiney - (des-ti-ny) - n. 1. deity of all things "
I have a database of 5.6 million records and I need to choose 5000 random
records. What would that query look like?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/