AFAIK, you can't use a placeholder with a SQL like statement. A coworker says you can. Can anyone confirm or deny it?
$query = 'select name from my_table where name like ?%';
my $sth = $dbh->prepare($query);
Basically he is convinced that you can. Nothing I've shown him has convinced him otherwise. Hopefully some prince or princess of the Perl Monks can break this stalemate
poj pointed out that I was incorrect. The percent sign belongs in the execute() not the prepare query.