Search code examples
phpmysqlregexmatch-against

Looking for a natural language match with SQL

I am using match() against() to match up different values across tables which are similar, however it is unable to match the following two values:

WERE HERE BECAUSE WERE LARGE and ANATHEMA were here because TS M

Even though it is able to match the following:

ANTHOLOGY 3 and BEATLES anthology 3 ALBUM COVER BADGE

But you can see that they are very similar, is there a way for match()against() to realise how similar they are? Since in terms of the the letters they contain these two values are more similar to each other than any other possible value it could match them against.

Solution

  • It is due to MySql Full-Text Stopwords were is the stopword

    you need to just add this to your .cnf file, restart mysql engine and rebuild indexes:

    ft_stopword_file = ""