RE: Random Selection

2001-07-06 Thread Don Read
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

Re: Random Selection

2001-07-06 Thread Greg Donald
> 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 "