|
|
Posted by J.O. Aho on 01/10/06 14:12
Stefan Rybacki wrote:
> J.O. Aho wrote:
>>> ...
>>> This don't fit the OP, as instance with a higher Rated_Sum should be picked
>>> more often than one with a low value, the way you suggest here would give each
>>> row the same chance to be in the top of the list.
>
> Correct.
>
>>> If wanting to get the results as in the first post, then procedure (mysql5) is
>>> the only way to get it, without using help of PHP, if not be that strict, then
>>> you can do it with subselects (mysql4) as Stefan suggested.
>
> What do you mean by strict. Don't I get the same distribution like your
> procedure except the fact of multiple entries having the same rated value?
OP wanted to have 1/511 chance for a single number, while your example had
1/500 according to your own post. So 'strictly' would be a 1/511 chance.
//Aho
Navigation:
[Reply to this message]
|