/SQL/Mysql select random rows large table

Mysql select random rows large table

SELECT name
  FROM random AS r1 JOIN
       (SELECT (RAND() *
                     (SELECT MAX(id)
                        FROM random)) AS id)
        AS r2
 WHERE r1.id >= r2.id
 ORDER BY r1.id ASC
 LIMIT 1;

Source: stackoverflow.com

Similar codes

0 vote257 views1 answer
Mysl like insert a variable
SQL
0 vote213 views1 answer
Netstat -tln mysql
SQL
0 vote207 views1 answer
Mysql a from on this page has
SQL
0 vote204 views1 answer
How to create a table based on another table in mysql
SQL
0 vote212 views1 answer
Find and replace query in wordpress\
SQL
0 vote252 views2 answers
Insert data into multiple tables mysql
SQL
6 votes215 views2 answers
Oracle trigger
SQL
0 vote208 views1 answer
Sql server change schema of a table
SQL
0 vote226 views1 answer
SQL Where-Klausel
SQL
18 votes286 views3 answers
Get the list of all tables in sql server
SQL