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