Hello! I have some problems with fulltext search in boolean mode using mysql 4.0.6. I try to use this query: mysql> SELECT * FROM molotok_lots WHERE MATCH (lot_name,lot_desc) mysql> AGAINST ('+some +text' IN BOOLEAN MODE); I got error : ERROR 1064: You have an error in your SQL syntax near 'BOOLEAN MODE)' at line 1
Type of table is MyISAM. How to fix this problem ? Thanks. _________________________ Anton Zabannikh --------------------------------------------------------------------- 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