select random record with added constraints
Posted on 2013-11-12
I have a table of emails and a number.
By this count, I have 9 emails.
using some deranged mathematical calcuations, I read this as 5 x email1's, 3xemail2's, and 1xemail3 => 9 total.
I want to pick a random email from the list using the number as a weight against the total count.
in this case, email1 has a 5:9 chance of being selected; email2 has a 3:9 chance of being selected, and so on for email3.
How do I select the random email from the list using those numbers as weights?