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


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