my $table_lit = $dbh->quote_identifier( $table );

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

...

$sth->execute('+herman +melville');