my @param = ; my $sql = ; my $array_ref = $dbh->selectall_arrayref($sql,undef,@param); #### my $dbh = ; my $sth = $dbh->prepare("select * from table where col1=? and col2=?"); ... @param = ("test1a","test1b"); $array_ref = $sth->selectall_arrayref($sth,undef,@param); ... @param = ("test2a","test2b); $array_ref = $sth->selectall_arrayref($sth,undef,@param); ...