At 11:32 -0400 5/7/02, Cummings, Shawn (GNAPs) wrote: >The RAND() syntax does not appear to be working for me. > >What version mySQL is required?
3.23.2. Prior to that, use SELECT something, any_col*0+RAND() AS r FROM sometable WHERE ... ORDER BY r LIMIT 10 > > >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