Hello,
I have a questions with limitations/restrictions that are around for
full text search.
I have a field with data like "XY-11443;....." and I need to find the
record. The original developer was using full text search and says that
all was working before the task switched hands.
The basic query is
select * from metadata where match(type) against ('+XY-11443' in boolean
mode);
This query spins through all of my records and gives no results.
However, if I remove the "XY-" and just do ('+11443' in boolean mode) I
get an immediate and correct result.
I believe there is something going on with the '-' in the string that is
causing trouble - like maybe a stop word or something - but can't find
exactly what is going on and more importantly "HOW TO FIX IT"
Any help would be awesome!
Laura
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
