You are here: Re: [PHP] How to find random records in a subset? « PHP « IT news, forums, messages
Re: [PHP] How to find random records in a subset?

Posted by Brian Dunning on 06/03/05 17:04

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.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация