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