Return to Snippet

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