http://www.perlmonks.org?node_id=1150706

mg9176 has asked for the wisdom of the Perl Monks concerning the following question:

I'm having a bit of trouble with a parameterized query - mysql as the datasource.

my $sql = 'SELECT something FROM atable WHERE data in (?);'; my $sth = $dbh->prepare($sql); my $rv = $sth->execute($data);

That all works fine and dandy, however if $data is something like

my $data = "1,2,3,4,5,6";

only the first value is passed into the query. Thoughts on a remedy?