##
my $sth = $dbh->prepare_cached( "SELECT bar2 FROM foo WHERE bar1 = ?" );
$sth->execute( 2 );
##
##
SELECT bar2 FROM foo WHERE bar1 = 2;
##
##
SELECT bar2 FROM foo WHERE bar1 = '2';
##
##
my $sth = $dbh->prepare_cached( "SELECT bar2 FROM foo WHERE bar1 = ?" );
$sth->bind_param( 1, 2, SQL_INTEGER );
$sth->execute();