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


##</code><code>##

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