MySQL Forums
Forum List  »  Full-Text Search

Re: Distance and Wildcards
Posted by: Thomas H.
Date: March 12, 2016 01:16AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1267
March 10, 2016 02:36AM
669
March 11, 2016 12:50PM
Re: Distance and Wildcards
799
March 12, 2016 01:16AM
632
March 12, 2016 11:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.