Hi
Your first statement looks ok to me but the one you have below has no
space before AGAINST. Otherwise, I cannot see the problem myself. Mike
----- Original Message -----
From: "Francis Van-Lare" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: July 12, 2003 2:42 AM
Subject: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR
> I have run this command without Stating IN BOOLEAN MODE and my search goes
> fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE
> OPTION IS ADDED , can anyone help ?
> Table is MyISAM type running on Linux 8.0
>
>
> SELECT isbn, title, suggestedretail FROM bookscatalogue WHERE MATCH
> (isbn, title ) AGAINST ('+Visual Basic.NET' IN BOOLEAN MODE);
>
> Returns:
>
> Error
>
> SQL-query :
>
> SELECT isbn, title, suggestedretail
> FROM bookscatalogue WHERE MATCH (isbn, title )AGAINST ('+Visual Basic.NET'
> IN BOOLEAN MODE )
>
> MySQL said:
>
> You have an error in your SQL syntax near 'BOOLEAN MODE
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
