Posted By

traeregan on 12/04/09

Tagged

Viewed 740 times

Favorited by 1 user(s)

/ Published in: SQL

Using subqueries...

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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

Comment:

You need to login to post a comment.