$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;