/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 vote333 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote352 views3 answers
CONTACT FORM SQL
SQL
0 vote331 views1 answer
Sql tablo hangi sp de
SQL
3 votes334 views1 answer
Oracle drop user
SQL
0 vote419 views1 answer
Sqlite display data in separated columns
SQL
0 vote320 views1 answer
Sql select by content lenght
SQL
0 vote333 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote340 views1 answer
How to find table lock and row lock in mysql
SQL
4 votes327 views2 answers
Select first and last row mysql
SQL
11 votes340 views2 answers
You are using safe update mode
SQL