Random selection from MySQL?

[c4n]

I have a MySQL database - how do I randomly select one line from the database in Perl? To make it more interesting, this line MUSTN'T have "option" set to "first";

Thanks

 

[sleipnir214]

Try issuing the query:

SELECT foo, bar from tablename order by rand() limit 1 Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[c4n]

It works, thanks!