in reply to How to select limited rows randomly in DBIx::Class?

:P

my @tickers = $schema
   ->resultset('TickerTable')
   ->search({},
            { order_by => \"RAND()",
              columns => ['DisplayName'],
              rows => 20 });

[download]

String refs (\"") are used as literals to the DB in this case.

In Section Seekers of Perl Wisdom