my $confidence_query = $dbh->prepare("select confidence_str from $table  where probeset_id = ?");

##</code><code>##

$confidence_query->execute('SNP_1');

##</code><code>##

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where probeset_id='SNP_1')