Hello Alex,

Yes I agree I should not have to use now().

But the random function does not seem to work with a very limiting where condition.

As in : Select * from rand_test where a < 4 order by rand() limit 3

If there are only 3 matching records for the condition then order by rand() does not appear to work.

I get a result of 3,2,1 for the above query every time with MySql version 3.23.

Could I not expect 1,2,3 or 2,3,1 or 3,2,1 or 2,1,3 or 1,3,2 or 3,1,2 as possible results ?

Thanks

cornball