my $sth = $dbh->prepare('SELECT * FROM `productTable` WHERE MATCH(`mfg`, `productID`, `desc`) AGAINST(?)');
$sth->execute($keywords);
# (untested)