/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 vote135 views2 answers
Script all indexes in a database
SQL
0 vote131 views1 answer
Multiple left join mysql
SQL
0 vote141 views1 answer
Reona
SQL
0 vote131 views1 answer
Android sqlite get rows count
SQL
0 vote178 views1 answer
Delete from table where length sql
SQL
3 votes94 views4 answers
Mysql delete duplicate rows
SQL
0 vote130 views1 answer
Drop all tables db2
SQL
0 vote162 views1 answer
How to change the field size of an existing column
SQL
0 vote126 views1 answer
What is the essence of SQL?
SQL
2 votes120 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL