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?
>
>>
>
>>
>
>>
>
>> --
>
>> MySQL General Mailing List
>
>> For list archives: http://lists.mysql.com/mysql
>
>> To unsubscribe: http://lists.mysql.com/mysql
>
