To get a random row from your table, you can use the following trick:
{code type=php}
SELECT * FROM myTable ORDER BY RAND() LIMIT 1
{/code}
This will return a single random row from myTable.
Keep in mind you can also use a WHERE clause to limit the set you are choosing a random record from.
This is a more efficient way of finding a random result than it would be if you returned all the records from the table and looped through them in your code.
