Random row from set of results

Question

I would like to know if it is possible to retrive one single random row from search results. I mean I have query like this:

SELECT mp.name,mp.icon,mp.id,mp.wspx,mp.wspy,ms.icon FROM maps_points as mp JOIN maps_section as ms ON(ms.id = mp.section)

I would like to get one random row from results generated from this query. Is that possible with one mysql query or should I just get all results and get this one random in PHP?

score 2 · Answer 1 · edited May 23 '17 at 10:25

2

a simple way is to add ORDER BY RAND() LIMIT 1 to the query. Do take a look at some of the reasons why this can be a bad idea though, e.g.

edited May 23 '17 at 10:25

Community

1
1

answered Jun 25 '13 at 13:06

Paul Dixon

295,876
54
310
348

score 0 · Answer 2 · answered Jun 25 '13 at 13:06

0

 SELECT mp.name,mp.icon,mp.id,mp.wspx,mp.wspy,ms.icon 
 FROM maps_points as mp 
 JOIN maps_section as ms ON(ms.id = mp.section) 
 ORDER BY RAND() LIMIT 1

answered Jun 25 '13 at 13:06

karmafunk

1,453
12
20

score -1 · Answer 3 · answered Jun 25 '13 at 13:31

-1

Ok, I knew this one, but is there better and faster way to do that ? I mean I've seen some other approaches but they were all about random row from table and I need to pick random row from some set of results :)

answered Jun 25 '13 at 13:31

Maksym

3,276
3
22
27

Welcome to stack overflow - please note that this isn't a forum, and you should only post answers which are actually answers. Comment on individual answers instead. – Paul Dixon Jun 25 '13 at 14:01

Random row from set of results

3 Answers3