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 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 ?
Hm..
It works fine for me:
mysql> select * from articles where match(body) against('+link +world' IN
BOOLEAN MODE);
+----+----------------------+
| id | body |
+----+----------------------+
| 1 | link it to the world |
+----+----------------------+
1 row in set (0.00 sec)
Note: that's supported since 4.0.1 and not in 3.23.x branch.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
