my $sth = $dbh->prepare("SELECT something WHERE field=?");
for (@list_of_stuff) {
  $sth->execute($_);
  push @results,$sth->fetchrow_arrayref();
}