List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 13 2002 1:19am
Subject:Re: Bug?
View as plain text  
At 17:30 -0700 10/12/02, Okami no Kaze wrote:
>I'm attempting to make a search engine with a MySQL
>back end, and have run into a little problem.
>I'm using the query:
>SELECT * FROM listings WHERE MATCH (Name, Description,
>Keywords) AGAINST ("searchString" IN BOOLEAN MODE)
>LIMIT 0,25
>And it returns:
>You have an error in your SQL syntax near 'BOOLEAN
>MODE) LIMIT 0,25' at line 1
>I checked the version information, and it returned

That's the problem.  Boolean mode searches were added in
4.0.1.  The manual states this pretty clearly:

>If someone can please help me, I'd be very greatful!
>"True words are rarely beautiful, and beautiful words are rarely true."
>		~Anon
>Project page:
>E-mail:               wolfmagic13d@stripped

Bug?Okami no Kaze13 Oct
  • Re: Bug?Paul DuBois13 Oct