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.
