MySQL Forums
Forum List  »  Full-Text Search

IN BOOLEAN MODE
Posted by: Mary White
Date: June 03, 2005 12:44PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
IN BOOLEAN MODE
5228
June 03, 2005 12:44PM
2644
June 11, 2005 12:25PM
2500
July 22, 2005 01:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.