Help for this page

Select Code to Download


  1. or download this
    my $sql = "SELECT foo FROM Bar WHERE 1=1";
my @bind;
$sql .= " AND baz in ( " . join(',', map {'?'} @ins) . ") ";
push @bind, @ins;
$dbh->selectall_arrayref($sql, {}, @bind);
  2. or download this
    use SQL::Abstract;
my $SA = SQL::Abstract->new;
my ($sql, @bind) = $SA->select('Bar', ['foo'], {baz => \@ins});
$dbh->selectall_arrayref($sql, {}, @bind);