Re: Fulltext boolean search results

2004-07-24 Thread Michael Stassen
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

2004-07-24 Thread leegold
<[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

2004-07-24 Thread Michael Stassen
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

2004-07-24 Thread leegold
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