mysql: fetching a random row

[unknown]

Is there any way I can fetch a totally random row with a single query?  I
know I can do a count(*); i = rand<result>; <query> limit <i>,1 but that
seems inelegant.  not to mention wasteful, making the server scan through
all those extra lines to get the one i want.

---
[EMAIL PROTECTED]


-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.