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

t; > 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 so

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

Fulltext boolean search and the asterix

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? -"S*Y" will return all. - FREE E

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

fulltext/boolean search

I created a search app with fulltext, boolean, etc. i have two forms, one that allows the user to just enter a basic search in a single input field and a more advanced form with additional input areas for advanced boolean searches.. now, when you do not specify a boolean operator, what does it

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... .

Fulltext boolean search results

If I search on: BT-1034.06 I get returned: BT-1034.02 BT-1034.03 BT-1034.05 ... BT-1034.11 If I put in "" ie. "BT-1034.06" I only get BT-1034.06 returned. The BT- part seems irrelevant. But I don't understand the results. Why so many returned? Seems like 1034.06 w/out the "" is unique enough. Is