Laura did this work... inquiring minds want to know :)
On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
