I have this full text search query
SELECT name, org_id, address_id
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?