my $table_lit   = $dbh->quote_identifier( $table );
my $pattern_lit = $dbh->quote( '+herman +melville' );

my $stmt = qq{
   SELECT *
     FROM $table_lit
    WHERE ( MATCH( Author ) AGAINST( $pattern_lit IN BOOLEAN MODE ) )
    ORDER BY Title
};

...

$sth->execute();