List:General Discussion« Previous MessageNext Message »
From:shawn green Date:July 2 2013 5:20pm
Subject:Re: Full text search and & sign as a part of the keyword
View as plain text  
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
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