[SQLObject] Select Single Random Record

[Adam B. <ada...@gm...>]

What is the best way to select a single random record from a table and
falls within the "where" criteria i have defined? I don't want to return a
huge result set each time and then pick a random one, as the database is
located outside of my network and accessed over the internet.


-- 
Adam Berg