[Gllug] Perl and MySQL question

[Adrian McMenamin]

I have this SELECT statement

  $qu1 = qq{SELECT name, date_in, text, id FROM yesindeed WHERE score < 5 
ORDER BY RAND() LIMIT 7};


When executed and a hashref is sought it successfully produces a random list 
except for the fact that it *always* returns the first record in yesindeed as 
the very first record (ie records 1 - 6 are randomly selected but record 0 is 
always the same one)

Is this a known problem (mysql 3.23.55) or is it me?

Adrian
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug