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

##</code><code>##

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