my $value_lookup = $dbh->prepare(" SELECT value WHERE id IN (1,2)"); #EXECUTE SQL QUERY $value_lookup->execute() or debug ($DBI::errstr); while(my($value) = $value_lookup->fetchrow_array()) { print "$value\n"; }