List:General Discussion« Previous MessageNext Message »
From:lamp Date:July 2 2013 9:40pm
Subject:RE: Full text search and & sign as a part of the keyword
View as plain text  
ft_min_word_len=3
stopwords! IDIOT! I was testing using stop words! :)

let me change my test org name.

thanks

> FULLTEXT (at least the MyISAM version) has 3 gotchas:
> ft_min_word_len=4, stopwords, and the 50% rule
>
>> -----Original Message-----
>> From: shawn green [mailto:shawn.l.green@stripped]
>> Sent: Tuesday, July 02, 2013 10:21 AM
>> To: mysql@stripped
>> Subject: Re: Full text search and & sign as a part of the keyword
>>
>> Hello,
>>
>> (my response is not top-posted)
>> On 7/2/2013 12:50 PM, lamp@stripped wrote:
>> >
>> >
>> >
>> > Another correction: Searching for "Com", the test org is NOT gonna be
>> > listed but all others will.
>> >
>> > Searching for "Com&" no results at all.
>> >
>> >
>> >
>> >
>> >
>> >>
>> >
>> >> Actually, looks like I'm wrong.
>> >
>> >> For testing purpose I made an org
>> >
>> >> "Comp&Me"
>> >
>> >> When search for "Comp" it's gonna
>> >
>> >> be shown on the list.
>> >
>> >>
>> >
>> >> When search for "Comp&" it's also gonna be shown.
>> > But
>> >
>> >> "Construction Company" as well.
>> >
>> >> Then I changed the name of
>> >
>> >> the test org to "Com&Me".
>> >
>> >>
>> >
>> >> Searching for "Com", the test org is gonna be listed.
>> >
>> >>
>> >
>> >> Though, "Com&" no results at
>> >
>> >> all.
>> >
>> >> ?!?
>> >
>> >>
>>
>> >>> Hi to all,
>> >>> I have this full text search query
>> >>> SELECT name, org_id,
>> >>> address_id
>> >>> FROM organization
>> >>> WHERE org_active='Y' AND MATCH(name) AGAINST('AB&C*' IN
>> >> BOOLEAN
>> >>> MODE)
>> >>> and I'm not getting any results. And there IS a org AB&C, Inc.
>> >>> My assumption is the ampersand sign as a part of the keyword.
>> >>> Any idea?
>> >
>>
>> Read this:
>> http://dev.mysql.com/doc/refman/5.5/en/server-system-
>> variables.html#sysvar_ft_boolean_syntax
>>
>> Then search on "Comp Me".
>>
>> Let us know your results.
>>
>> --
>> Shawn Green
>> MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware
>> and
>> Software, Engineered to Work Together.
>> Office: Blountville, TN
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
Full text search and & sign as a part of the keywordlamp2 Jul
  • Re: Full text search and & sign as a part of the keywordlamp2 Jul
    • Re: Full text search and & sign as a part of the keywordlamp2 Jul
      • Re: Full text search and & sign as a part of the keywordshawn green2 Jul
        • RE: Full text search and & sign as a part of the keywordRick James2 Jul
  • RE: Full text search and & sign as a part of the keywordlamp2 Jul