re: fulltext search in boolean mode problems

2002-12-28 Thread Egor Egorov
On Saturday 28 December 2002 11:40, Anton Zabannikh wrote: > 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 erro

fulltext search in boolean mode problems

2002-12-28 Thread Anton Zabannikh
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 'BOOLE