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