|
Posted by Alexey Kulentsov on 05/29/07 11:55
alpha.beta0@googlemail.com wrote:
> I have a MySQL table of servers, I use RAND() to pick a random server
> to use each time, but how can I add a number to each server entry that
> allows it be to picked more often than the other 20 servers?
>
> For example Server1's weight is 80 and Server2's weight is 40 and
> hence Server1 is more likely to be picked than the others.
>
SELECT *, weight*RAND() as result FROM Servers ORDER BY result LIMIT 1
Navigation:
[Reply to this message]
|