Grabbing a Random Record

[Rulkster]

Hi,

I am using PHP and MySQL.

What is the best way to grab a random record from a table if:

1. I do not know the total number of records in the table.

2. I do not know the unique primary key record id number

Thanks

[planetsim]

SELECT * FROM mytable ORDER BY RAND() LIMIT 1