grabmail
02-24-2006, 05:12 PM
I am experiencing a weird result set
MATCH(text)
AGAINST('pine* sucks* market* apple* "apple pie" ')
pine* sucks* market* doesn't match any result
The only results are from apple*
There is 2 rows that has the text 'apples'
if i remove "apple pie" from the list, the 2 rows will be returned
if i add "apple pie" into the against list, the 2 rows will disappear.
why is this so? does "apple pie" overwrite and convert apple* to simply apple?
cause' i'm only getting rows that have the exact word 'apple' in the text
Also, sometimes if i add more wildcards into the query like
MATCH(text)
AGAINST('pine* sucks* text1* text2* text3* text4* market* apple* ')
mysql stop searching for apple* and just search for apple.
Is this some automatic overwrite when there is too many wildcards?
MATCH(text)
AGAINST('pine* sucks* market* apple* "apple pie" ')
pine* sucks* market* doesn't match any result
The only results are from apple*
There is 2 rows that has the text 'apples'
if i remove "apple pie" from the list, the 2 rows will be returned
if i add "apple pie" into the against list, the 2 rows will disappear.
why is this so? does "apple pie" overwrite and convert apple* to simply apple?
cause' i'm only getting rows that have the exact word 'apple' in the text
Also, sometimes if i add more wildcards into the query like
MATCH(text)
AGAINST('pine* sucks* text1* text2* text3* text4* market* apple* ')
mysql stop searching for apple* and just search for apple.
Is this some automatic overwrite when there is too many wildcards?
