List:General Discussion« Previous MessageNext Message »
From:lamp Date:July 2 2013 4:50pm
Subject:Re: Full text search and & sign as a part of the keyword
View as plain text  


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?

>

>>

>

>>

>

>>

>

>> --

>

>> MySQL General Mailing List

>

>> For list archives: http://lists.mysql.com/mysql

>

>> To unsubscribe: http://lists.mysql.com/mysql

>


Thread
Full text search and & sign as a part of the keywordlamp2 Jul
  • Re: Full text search and & sign as a part of the keywordlamp2 Jul
    • Re: Full text search and & sign as a part of the keywordlamp2 Jul
      • Re: Full text search and & sign as a part of the keywordshawn green2 Jul
        • RE: Full text search and & sign as a part of the keywordRick James2 Jul
  • RE: Full text search and & sign as a part of the keywordlamp2 Jul