Fulltext mysql search does not work correctly. Where is the mistake?

Question

PHP

In the database of the online store, I decided to use full-text search. Put indexes on the required fields, translated the table into MyISAM. Using the query SELECT * FROM 'tableName' WHERE MATCH(field) AGAINST('Paper'); I get zero rows, if I look for another word, for example, ginger, then what is needed is returned. What is the reason for this selective return of results? With the help of Like, everything is searched perfectly.

Answer 1

Apparently the word paper occurs so often that mysql considers it a stop word

Answer 2

You have this word either in stop words, or it occurs in half of the entries.
In general, there is an error in the phrase "Fulltext mysql search", for this it is better to use sphinxsearch / elasticsearch