random rows

From: Ing. Branislav Gerzo (2ge_at_2ge.us)
Date: 02/14/05 

Date: Mon, 14 Feb 2005 16:34:49 +0100
To: dbi-users@perl.org

Hi all,

I have one simple question - how I can return 10 random rows
from select?

For example we have select:

Select name, street, date
from people
order by date desc
limit 0,100

Now, I want return 10 random peoples. How to do it ? It is possible
via SQL statement, or I have to care about that in perl code ? If yes,
could you write me best method ?

Thanks a lot.