MySQL Forums
Forum List  »  Full-Text Search

Distance and Wildcards
Posted by: Thomas Henz
Date: March 10, 2016 02:36AM

Dear all,

I'm running a full text index on a rather huge database which I'd like to run the following query against:

[...]
MATCH(doc_text) AGAINST ('"+capital* +market* +union*" @5' IN BOOLEAN MODE)
[...]

This query returns results for anything, that contains the words "capital market union" in a max. distance of 5 words.

However, it does not return anything in the distance of 5 words that is "capital markets union" - notice the s in markets, which I'd like to cover with the wildcard. Why?

Of course, if I change it to

[...]
MATCH(doc_text) AGAINST ('+capital* +market* +union*' IN BOOLEAN MODE)
[...]

I get anything that contains capital, market, markets, union, unions separately somewhere in the text.

How can I use distance + wildcard?

Thanks a lot,
Thomas

Options: ReplyQuote


Subject
Views
Written By
Posted
Distance and Wildcards
3129
March 10, 2016 02:36AM
1285
March 11, 2016 12:50PM
1567
March 12, 2016 01:16AM
1248
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.