Order By Rand() Alternative - SQL Snipplr Social Repository

Revision: 21129

at December 4, 2009 00:17 by traeregan

Initial Code

SELECT name FROM tablename
WHERE id >= FLOOR( RAND( ) * ( SELECT MAX( id ) FROM tablename ) )
ORDER BY id ASC
LIMIT 1

Initial URL

http://www.phpfreaks.com/forums/index.php?topic=125759.0

Initial Description

Using subqueries...

Initial Title

Order By Rand() Alternative

Initial Tags

Initial Language

SQL