Web Hosting Talk







View Full Version : Is there a limit to Wildcards in mysql boolean full text search?


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?