FULLTEXT (at least the MyISAM version) has 3 gotchas: ft_min_word_len=4, stopwords, and the 50% rule
> -----Original Message----- > From: shawn green [mailto:shawn.l.gr...@oracle.com] > Sent: Tuesday, July 02, 2013 10:21 AM > To: mysql@lists.mysql.com > Subject: Re: Full text search and & sign as a part of the keyword > > Hello, > > (my response is not top-posted) > On 7/2/2013 12:50 PM, l...@afan.net 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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
