Re: Fulltext boolean search and the asterix

Paul DuBois wrote: At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: 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? " To use a literal instance of a special character in a regular expression, precede it by

Re: Fulltext boolean search and the asterix

At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: 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 *. The manual comes

Re: Fulltext boolean search and the asterix

Lindsey wrote: 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 *. The manual comes again to the rescue ;-) Appendix G [1] tells us:

Re: Fulltext boolean search and the asterix

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 tabl

Re: Fulltext boolean search and the asterix

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 h

Re: fulltext/boolean search

Hi! Check the manual for ft_boolean_syntax variable. It defines what character is used for every operator. Space marks "default" operator - so you can change it. On Jun 06, Sebastian wrote: > I created a search app with fulltext, boolean, etc. i have two forms, > one that allows the user to jus

Re: Fulltext boolean search results

leegold wrote: <[EMAIL PROTECTED]> said: From the manual : MySQL uses a very simple parser to split text into words. A word is any sequence of characters consisting of letters, digits, ', or _. Some words are ignored in full-text searches: An

Re: Fulltext boolean search results

<[EMAIL PROTECTED]> said: > From the manual > : > > > MySQL uses a very simple parser to split text into words. A word is any > > sequence of characters consisting of letters, digits, ', or _. Some > > words are ignored in full-text search

Re: Fulltext boolean search results

From the manual : MySQL uses a very simple parser to split text into words. A word is any sequence of characters consisting of letters, digits, ', or _. Some words are ignored in full-text searches: Any word that is too short is ignored... .