Help with match('...') against('...' in boolean mode);

[TCovert]

Does anyone see anything wrong with this code? Everytime I run this with the "in boolean mode" in the statement, it gives me an error. Here is the code, and the error:

SELECT DISTINCT stories.story_id, DATE_FORMAT(stories.pub_date, '%Y %m-%d'), stories.pub_id, stories.section_id, stories.page, stories.series, stories.keyword_id, stories.byline, stories.headline, stories.intro, stories.bodytext, stories.correction, stories.correction_date, stories.label FROM stories WHERE match(stories.byline) AGAINST('+baker' in boolean mode) AND stories.pub_date BETWEEN '2002-12-01' AND '2002-12-31' ORDER BY stories.pub_date DESC

Error:  "You have an error in your SQL syntax near 'boolean mode AND stories.pub_date BETWEEN '2002-12-01' AND '2002-12-31' ORDER BY' at line 1"

Where did I go wrong?  I am using PHP Version 4.0.4pl1 and MySQL 3.23.33

Thanks.

[diego25]

Directly from the MySQL manual:

MATCH (col1,col2,...) AGAINST (expr IN BOOLEAN MODE)
MATCH ... AGAINST() is used for full-text search and returns relevance - similarity measure between the text in columns (col1,col2,...) and the query expr. Relevance is a positive floating-point number. Zero relevance means no similarity. MATCH ... AGAINST() is available in MySQL version 3.23.23 or later. IN BOOLEAN MODE extension was added in version 4.0.1. For details and usage examples, see section 6.8 MySQL Full-text Search.

Diego