in reply to Re^2: DBI/DBD::mysql placeholders and full text searches
in thread DBI:MYSQL placeholders and full text searches

quote_identifier and quote convert text into SQL identifiers (e.g. table names) and SQL string literals respectively.

By the way,

my $executable = '+'. $melville . ' +' . $herman;
is just a long winded way of saying
my $executable = "+$melville +$herman";

Something to think about: What happens if $melville contains a space?