Laura:
Perhaps the "-" is acting like a Boolean operator. What if you put
double quotes around your search phrase:
SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN
BOOLEAN MODE );
Wes
On Wed, 29 Sep 2004 13:22:54 -0400, Laura Scott <[EMAIL PROTECTED]> wrote:
>
>
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
