Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-15 Thread Paul DuBois 
At 19:28 -0400 7/15/03, Francis Van-Lare wrote:
I have MySQL version 3.23 on Linux 8.0  . I am trying to do a full text
search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN
MODE  option my query runs fine .  Does it mean I have to upgrade to 4.0
to use this Search mode?   Can somebody please confirm ?
The MySQL Reference Manual confirms it:

http://www.mysql.com/doc/en/Fulltext_Search.html

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-15 Thread Francis Van-Lare 
I have MySQL version 3.23 on Linux 8.0  . I am trying to do a full text
search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN
MODE  option my query runs fine .  Does it mean I have to upgrade to 4.0
to use this Search mode?   Can somebody please confirm ?



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-12 Thread Victoria Reznichenko 
"Francis Van-Lare" <[EMAIL PROTECTED]> wrote:
> 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

Which version of MySQL server do you use? IN BOOLEAN MODE is supported since 4.0.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-12 Thread O'K Web Design 
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]

RE: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-12 Thread electroteque 
the only thing i could see a problem is the decimal but maybe not

-Original Message-
From: Francis Van-Lare [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 4:42 PM
To: [EMAIL PROTECTED]
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]

MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

2003-07-11 Thread Francis Van-Lare 
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]