SQL Random query

Question

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).

score 0 · Accepted Answer · answered Apr 04 '12 at 08:10

0

Google should help you with this: http://akinas.com/pages/en/blog/mysql_random_row/

answered Apr 04 '12 at 08:10

satnhak

9,407
5
63
81

That's just randomly. But I want the chance to be RatingOfThisElement/AllRatings, not 1/NumElements like in your example. – user1200226 Apr 04 '12 at 08:46
The point is you need to know how to generate randomness. You need to work out how to apply randomness to your situation. – satnhak Apr 04 '12 at 10:06

score 0 · Answer 2 · edited May 23 '17 at 10:34

0

You can use ORDER BY RAND() LIMIT 10 such as here MySQL: Alternatives to ORDER BY RAND() but there are issues with ORDER BY RAND in MySQL if used in certain ways. It can case huge performance issues and you may be better off doing it in PHP - alternatives to ORDER BY RAND

edited May 23 '17 at 10:34

Community

1
1

answered Apr 04 '12 at 08:11

liquorvicar

6,081
1
16
21

That's just randomly,too. But I want the chance to be RatingOfThisElement/AllRatings, not 1/NumElements like in your example. – user1200226 Apr 04 '12 at 08:47

score 0 · Answer 3 · answered Apr 04 '12 at 08:19

0

here is the solution

SELECT * FROM yourtablename ORDER BY RAND() LIMIT 0,10;

answered Apr 04 '12 at 08:19

IT ppl

2,626
1
39
56

If you look at the link I posted that has worse performance than a php query. – satnhak Apr 04 '12 at 08:29
but user1200226 didn't tag PHP ;) – IT ppl Apr 04 '12 at 11:31

SQL Random query

3 Answers3