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. Something like SELECT * FROM table1 LIMIT RAND(10); I know this syntax is wrong I need to know the right one Thanks. PaT! mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
