ft_min_word_len=3 stopwords! IDIOT! I was testing using stop words! :) let me change my test org name.
thanks > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
