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: [EMAIL PROTECTED] > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
