What version of MySQL are you currently running? This SQL query runs ok on here and my test box. It looks like perhaps you're using an older version of MySQL that doesn't support fulltext boolean mode?