List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 15 2000 5:32pm
Subject:Re: Problem with RAND()
View as plain text  
At 1:24 PM -0400 09-15-2000, Clint Gilders wrote:
>Hi
>	I feel like such a bozo, but I am just learning MySQL and seem to be
>doing ok until..... I had the need  for sorting query results
>randomly.   I get to the ORDER BY RAND() part an all he|| breaks
>loose.   I am using Paul DuBois' book and whenever I issue a query such
>as :
>	SELECT * FROM table_name ORDER BY RAND();
>
>I get:
>	You have an error in your SQl systax near 'RAND()'at line 1
>
>I have even used the sample databases used in the book and I still get
>the error.
>
>Can someone please explain how to go about sorting query results in
>random order.

If your MySQL version is older than 3.23.3, that won't work.  See
page 188 of the book for a workaround for older versions.

-- 
Paul DuBois, paul@stripped
Thread
Problem with RAND()Clint Gilders15 Sep
  • Re: Problem with RAND()Paul DuBois15 Sep
  • Re: Problem with RAND()Clint Gilders15 Sep
    • Re: Problem with RAND()Paul DuBois15 Sep