MySQL Error Occurred

Error Message:
1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Bounty *** Natures L-Lysine 1000Mg 6011 60Tb By by ') AND status=0 AND prod...' at line 2

SQL:
SELECT productId, rating,trating, image, price, name, sale_price FROM cubecart_inventory WHERE MATCH (name) AGAINST ('Nature's Bounty *** Natures L-Lysine 1000Mg 6011 60Tb By by ') AND status=0 AND prod_flag = 0 LIMIT 8