I have a question. If I wanted to sort randomly on a column weighted by the value of the column will does this query work SELECT val_column, val_column*0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit 10; This should five me a random row weighted by the value of the column is this correct? Seems to be but I might be wrong. Thanks for any tips -- Dathan
- Re: Hmm looks like this query works Dathan Vance Pattishall
- Re: Hmm looks like this query works Becoming Digital
- RE: Hmm looks like this query works Dathan Vance Pattishall
- RE: Hmm looks like this query works Eric Wagner
- RE: Hmm looks like this query works Andrew Braithwaite
- RE: Hmm looks like this query works Andrew Braithwaite