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:shawn@stripped]
Sent: Tuesday, May 07, 2002 11:33 AM
To: monty@stripped; Ulf Harnhammar
Cc: mysql@stripped
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 <ulf@stripped> 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 <mysql-thread108227@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-c-gurhan.ozen=wcom.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
