MySQL error in file: /engine/modules/show.full.php at line 623

Error Number: 1064

The Error returned was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Special* 8 Ball *Book $6,995* *We Ship!*') AND id != 221022 AND approve=1 AND ' at line 1

SQL query:

SELECT id, date, short_story, xfields, title, category, alt_name FROM dle_post WHERE MATCH (title) AGAINST ('2009 Victory Vegas 8-Ball - *Manager's Special* 8 Ball *Book $6,995* *We Ship!*') AND id != 221022 AND approve=1 AND date <= NOW() AND date < '2024-04-19 23:25:36' LIMIT 10