my @query_ids = (5,4,3,2,1); my $sql = q/select rec_data from foo where id in (/ . join(",", @query_ids) . q/) order by id/; my $results = $dbh->selectall_arrayref($sql);