note 71369 added to function.array-rand

Instead of using the horrible slow select * from some_table order by rand() limit 1; have a look at this more performant solution from http://jan.kneschke.de/projects/mysql/order-by-rand/ SELECT * FROM some_table AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM some_table)) AS id) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 1; ---- Server IP: 66.163.161.117 Probable Submitter: 91.64.129.10 ---- Manual Page -- http://www.php.net/manual/en/function.array-rand.php Edit -- https://master.php.net/note/edit/71369 Del: integrated -- https://master.php.net/note/delete/71369/integrated Del: useless -- https://master.php.net/note/delete/71369/useless Del: bad code -- https://master.php.net/note/delete/71369/bad+code Del: spam -- https://master.php.net/note/delete/71369/spam Del: non-english -- https://master.php.net/note/delete/71369/non-english Del: in docs -- https://master.php.net/note/delete/71369/in+docs Del: other reasons-- https://master.php.net/note/delete/71369 Reject -- https://master.php.net/note/reject/71369 Search -- https://master.php.net/manage/user-notes.php