Quote:
|
Originally Posted by fatdicksimon
you should be able to do
ORDER BY RAND(), probability_index DESC LIMIT 1
|
This doesn't solve it, this just sorts it by the random number and doesn't take the probability_index into account (only if the RAND() number is generated absolutely the same for 2 fields, which doesnt happen really often)