my $sql = q{SELECT * FROM tblX WHERE condition1 = ? and condition2 = ?}; my $sth = $dbh->prepare($sql); $sth->execute(@array);