ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
Quoting Jigal van Hemert <[EMAIL PROTECTED]>:
> Lindsey wrote:
> > Lets say the table contains the following brands
> >
> > SAMSUNG
> > SIEMENS
> > SONY
> >
> > If you do a fulltext boolean search with the term:
> > -S*Y
> > -(S*Y)
> >
> > everyting that starts with an S will be excluded... any solutions?
>
> Although I couldn't find a question in your post, I guess you want to
> know how to find anything that does not (start with 's' and ends with
> 'y').
>
> Unfortunately the asterisk ('*') will not help, because the manual [1]
> states:
> " The asterisk serves as the truncation operator. Unlike the other
> operators, it should be *appended* to the word to be affected. "
>
> I don't think that full-text indexes were meant for this kind of
> queries; although it will not use an index at all (so it might be a slow
>
> query), using LIKE 'S%Y' or using a regular expression might be a
> possible solution.
>
> [1] http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
>
> Regards, Jigal.
>
-------------------------------------------------
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
