Joe Rhett wrote:
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 f
> > Based on a guess, or did you analyze the data file I sent?
>
> Based on your data.
.. ..
> And of course I tried this myself before writing to you :)
Cool. Thanks for the analysis.
> > And if so, may I suggest that the upgrade documentation REALLY needs to
> > be broke
Hi!
On Jan 13, Joe Rhett wrote:
> > 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'.
>
> Based on a guess
> 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'.
Based on a guess, or did you analyze the data file I sent?
And
> >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 No
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.
>
[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
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.
I
>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 Notic