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

2013-07-03 Thread lamp
en [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

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

2013-07-02 Thread lamp
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", th

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

2013-07-02 Thread Rick James
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 searc

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

2013-07-02 Thread lamp
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.

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

2013-07-02 Thread shawn green
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 mad