Re^2: SQL prepared statements using MySQL In ()

[djlerman]

Thank You. This is similar to how I solved it.

# Set up variable for the Parameters for the entire query
my @sqlParameters = ();

# set up variable for just the IN() statement
my @valuesForIn = (1,2,3,4,5);

# a value for another field
my $field3 = 'abc123';

my $query = "   SELECT field1
                FROM table1
                WHERE field2 IN (@{[join',', ('?') x @valuesForIn]}) 
                    AND field3 = ? ";

push(@sqlParameters, @valuesForIn);
push(@sqlParameters, $field3);

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

$sth->execute(@sqlParameters) or die $dbh->errstr;

Note: I kept separate @sqlParameters variable J.I.C. the query needs to be extended with more parameters.