Re: Distance and Wildcards

[Thomas H.]

Dear Rick,

thanks for your reply.

It's InnoDB. Please note that I am actually using the @ as a distance operator.

I'm just adding wildcards, which seems to break it.

Manual:
@distance operator, for example, MATCH(col1) AGAINST('"word1 word2 word3" @8' IN BOOLEAN MODE)

Modification:
@distance operator, for example, MATCH(col1) AGAINST('"word1* word2* word3*" @8' IN BOOLEAN MODE)

Note the wildcard - It brings me zero results although there should be some.

Thanks,
Thomas