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
