Full text search and & sign as a part of the keyword

Question

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?

Comments

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.

---

Another correction: Searching for "Com", the test org is NOT gonna be listed but all others will.
Searching for "Com&" no results at all.

Answer 1

Read this:
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_ft_boolean_syntax

Then search on "Comp Me".