Hi!
On Jan 07, [EMAIL PROTECTED] wrote:
> >Description:
> Boolean mode fulltext searching returns zero hits for valid queries.
> >How-To-Repeat:
> Create a database with a Text column. Add a fulltext index on it.
> Try to search for multiple words with AND or phrase syntax.
>
> Here are examples:
>
> mysql> select Notice_ID from Notices where match (Text) against
> ('+pollution +control' in boolean mode);
> Empty set (0.00 sec)
>
> mysql> select Notice_ID from Notices where match (Text) against
> ('"pollution control"' in boolean mode);
> Empty set (0.02 sec)
>
> mysql> select Notice_ID from Notices where Text like '%pollution control%';
>
> +-----------+
> | Notice_ID |
> +-----------+
> | 192090 |
> +-----------+
> 1 row in set (5.00 sec)
Not a bug.
In the manual, section "Upgrading from Version 3.23 to 4.0", there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
