top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
265 views

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?

posted Jul 2, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
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.
Another correction: Searching for "Com", the test org is NOT gonna be listed but all others will.
Searching for "Com&" no results at all.

1 Answer

0 votes
answer Jul 2, 2013 by anonymous
Similar Questions
+2 votes

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

+1 vote

I did a test install of Fedora 19 on a spare machine and discovered that MySQL is no longer part of the Distro being replaced by MariaDB.

Has anyone tried to run WordPress in conjunction with MariaDB and if so any problems.

...