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]