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
