http://qs321.pair.com?node_id=233068


in reply to Perl and MySQL - getting a random record

I agree this has nothing to do with perl... and Cody's post got me thinking. try 
 SELECT *, rand() as rand 
  FROM Banner_Rotator 
  ORDER BY rand LIMIT 1

[download]
tstock

In Section Seekers of Perl Wisdom