[RESOLVED] Random question

[scialom]

Hello,

I have a MySQL table with 200 items. Each item has a rate between 1-10.
I need to select 20 random items but give more weight for the lower rank. So the ideal results will be more lower rank and just few higher rank but all random. Is it possible?

thanks!

[bradgrafelman]

Have you tried Google'ing yet? A quick search for "sql weighted random" presented numerous results (example).

[scialom]

thanks. in order to search I would have to know the term which I didn't...
But your link provided me the answers.

Thank you!