SQL prepared statements using MySQL In ()

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

I am trying to create a prepared statement with perl using MySQL's IN (). It looks something like this:

$valuesForIn = "1,2,3,4,5";

$query = "   SELECT field1
                FROM table1
                WHERE field2 IN (?) ";

$sth1 = $dbh->prepare($query) or die->$errstr();

$sth1->execute($valuesForIn) or die $dbh->errstr;
[download]

This doesn't seem to work. :-( What is the useful wisdom around this?

Back to Seekers of Perl Wisdom