SELECT * FROM table WHERE MATCH (one,two) AGAINST ('+слово1+слово2+слово3+слово4+слово5')

It is necessary to filter the result so that the answer contains fields with at least 80% of the specified words.

  • one
    Relevance is not correlated in the NUMBER of words. It is necessary - count separately and filter according to the calculated quantity. - Akina

0