IN BOOLEAN MODE

[Mary White]

MySQL 4.3.6 accepts the following command:

SELECT id, caption
FROM products
WHERE
MATCH ( caption )
AGAINST ( 'Girl Bunny')

But I receive an error when I add IN BOOLEAN MODE:

SQL-query :

SELECT id, caption
FROM products
WHERE
MATCH (

caption
)
AGAINST (
'+Girl Bunny'
IN BOOLEAN
MODE
)
LIMIT 0 , 30

MySQL said:


You have an error in your SQL syntax near 'BOOLEAN
MODE ) LIMIT 0, 30' at line 6

Any Ideas?