/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

27 votes396 views3 answers
Mysql delete row
SQL
1 vote357 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote323 views1 answer
Grepper sql workbench download
SQL
3 votes331 views1 answer
Oracle show trigger code
SQL
0 vote335 views2 answers
How to set global time_zone in mysql
SQL
0 vote341 views1 answer
Creation d'un trigger sql
SQL
16 votes339 views2 answers
Add column if not exists mysql
SQL
0 vote335 views1 answer
Declarative base sqlalchemy
SQL
3 votes336 views2 answers
Enter mysql command line
SQL
0 vote340 views1 answer
Isnull in sqlite
SQL