SQL Random query
In my MySQL Database all the entries have a rating(an Integer). Now I want to have a SQL query that delivers 10 elements randomly. And as you probably guess, an element's chance to be taken should be RatingOfThisElement/AllRatings. How can I do that. (I know how to do it in php but I'd like to have a SQL query because of the performance).
SQL Random query
===

In my MySQL Database all the entries have a rating(an Integer). Now I want to have a SQL query that delivers 10 elements randomly. And as you probably guess, an element's chance to be taken should be RatingOfThisElement/AllRatings. How can I do that. (I know how to do it in php but I'd like to have a SQL query because of the performance).