You can't do "ORDER BY RAND()" prior to version 3.23...
On your 3.22.32 version do something like:
SELECT column_name*0+RAND() AS rnd FROM table_name WHERE IsActive=1 ORDER
BY rnd LIMIT 1;
Gurhan
-Original Message-
From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 1
At 13:26 -0700 5/14/02, Soheil Shaghaghi wrote:
>Hello All,
>I am running 2 MySQL servers, one on Linux, and the other on FreeBSD.
>Linux, MySQL version: 3.23.49
>FreeBSD, MySQL version: 3.22.32
>
>Problem:
>
>The following code runs on the newer version of MySQL, and Linux, but when I
>run it on
