RE: select with random result

Try SELECT * FROM table1 ORDER BY RAND() LIMIT 10; -Original Message- From: PaT! [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: select with random result Hi, how can I write a select where I have a limit result of records but random

select with random result

Hi, how can I write a select where I have a limit result of records but random. Something like SELECT * FROM table1 LIMIT RAND(10); I know this syntax is wrong I need to know the right one Thanks. PaT! mysql