You have to have MySQL 3.23 or greater.. http://www.mysql.com/doc/M/a/Mathematical_functions.html
Gurhan -----Original Message----- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:33 AM To: [EMAIL PROTECTED]; Ulf Harnhammar Cc: [EMAIL PROTECTED] Subject: Using RAND() The RAND() syntax does not appear to be working for me. What version mySQL is required? At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote: >Hi! > > >>>>> "Ulf" == Ulf Harnhammar <[EMAIL PROTECTED]> writes: > >Ulf> On Sun, 27 Jan 2002, Michael Widenius wrote: > >> One way to do this is to do as follows: > >> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY > >> RAND() LIMIT 10 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
