my $id_string = '1,2'; my $value_lookup = $dbh->prepare(" SELECT value WHERE id IN (?)"); #EXECUTE SQL QUERY $value_lookup->bind_param(1, $id_string); $value_lookup->execute() or debug ($DBI::errstr); while(my($value) = $value_lookup->fetchrow_array()) { print "$value\n"; } #### 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"; }