Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-11 Thread Sergei Golubchik
Hi! On Feb 05, Tue Tønning wrote: > Hey, > > I have discovered a strange error in the mysql versions mentioned in subj. > > Example. > A table with 10 entries ...i want to draw 3 randomly > => "select fieldName from tableName order by RAND() limit 3" > > this have worked for the last year or so

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-08 Thread Aman Raheja
HINT: I have used PERL to generate random numbers and then do a SELECT on the auto_increment field in the mysql table, thus generating random picks from my tables; I'll be glad to bet informed of better ways around, though :) Thanks Aman Raheja AGF Inc. - Original Message - From: "Tue Tøn