List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:February 1 2007 6:52pm
Subject:RE: Fulltext search dilemma (IN BOOLEAN MODE)
View as plain text  
Unless you changed the minimum word length, "Key" would be ignored because
it is too short. I would think the quotation marks at the start or end of
the words would be ignored. The asterisk operator is only valid at the end
of a word. Those initial asterisks, and the quotation marks, would be
treated as word delimiters as far as I can tell.

Also, the asterisk operator is only valid at the end of a word, not in the
beginning. The leading asterisks should be ignored, since they would be
treated as word delimiters.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341


> -----Original Message-----
> From: Andreas Iwanowski [mailto:namezero@stripped]
> Sent: Thursday, February 01, 2007 12:49 PM
> To: mysql@stripped
> Subject: Fulltext search dilemma (IN BOOLEAN MODE)
>
> Hello MySQL experts,
>
> I'm trying to do a full text search on an indexed Keywords column that
> contains quotation marks, and it's giving me a headache.
>
> Suppose there are records in the database containing the folling
> keywords:
> 1. "Miami Beach" City
> 2. "Key West" Florida
> 3. "Key West" Beach Florida
>
> Now I do two fulltext searches on this column like this:
> SELECT * FROM _my_table_here WHERE MATCH(Keywords) AGAINST ('*Key*
> *West*' IN BOOLEAN MODE)>0;
> SELECT * FROM _my_table_here WHERE MATCH(Keywords) AGAINST ('*Miami*
> *Beach*' IN BOOLEAN MODE)>0;
>
> The second query returns the correct rows in spite of the " preceding
> Miami.
> The first one, however, returns no results, even though there are rows
> in the table that *should* match the query.
> I think is has something to do with noise words, since if I have a row
> like this one:
>
> 4. Key West
>
> Then the problem does not occur and the search returns that row.
>
>
> Any help would be appreciated.
>
>
>
> -Andy
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>



Thread
Fulltext search dilemma (IN BOOLEAN MODE)Andreas Iwanowski1 Feb
  • RE: Fulltext search dilemma (IN BOOLEAN MODE)Jerry Schwartz1 Feb
RE: Fulltext search dilemma (IN BOOLEAN MODE)Andreas Iwanowski1 Feb
  • RE: Fulltext search dilemma (IN BOOLEAN MODE)Jerry Schwartz1 Feb