randomly pick a row from database

[nagasea]

can someone show me how to fetch a row in database table randomly

here's the table:

1 Book
4 Water
8 Wood
9 Glass

[drawmack]

SELECT * FROM <table> ORDER BY RAND() LIMIT 0,1

[nagasea]

Originally posted by drawmack
SELECT * FROM <table> ORDER BY RAND() LIMIT 0,1

is this code good for huge database size ?

[drawmack]

it only retrieves one record, it's good for any size db.