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
>'3.23.46'.

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

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

>
>If someone can please help me, I'd be very greatful!
>
>~Michael
>
>=====
>"True words are rarely beautiful, and beautiful words are rarely true."
>		~Anon
>
>GatewayMU:            http://gatewaymu.sourceforge.net
>Project page:         http://sourceforge.net/projects/gatewaymu
>E-mail:               wolfmagic13d@stripped
>

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