How to pull a random entry from a tablet?

Question

MySQL

I know this way:
select * from table order by rand() limit 1
But the execution speed is depressing, but what do you use?

Answer 1

Change `table` to the name of your table, and tell me if there's a speed boost.

SELECT tab1.`id`  FROM `table` AS tab1
  JOIN
    (SELECT
      (  RAND() * (SELECT MAX(id) FROM `table`) ) 
    AS id )
  AS tab2
 WHERE tab1.id >= tab2.id
 ORDER BY tab1.id ASC
 LIMIT 1;

Answer 2

$id = rand(1....10000)
select * from where id=$id

Answer 3

MySql does not have a normal random selection functionality. So use rand()

$rez = mysql_query("SELECT id from table")
$id = array_rand(mysql_fetch_array($rez))['id'];

This code will exclude non-existent id in the table