DBI parameterized database query with comma seperated list

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);
[download]

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

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

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