Re: Inconsistency in Mysql Full text Indexing

[Peter Brawley]

Your Match works for the 'sjc' substring, which follows a hyphen, but not for 'vapp', which has no such marker beside it. We overlooked the fact that In Natural Language Mode, Match() looks at words, not part-words.

See https://stackoverflow.com/questions/28278150/mysql-efficient-search-with-partial-word-match-and-relevancy-score-fulltext for using Match(0 to find part-words.



Edited 1 time(s). Last edit at 06/11/2019 08:24PM by Peter Brawley.