I did a search with MATCH AGAINST, it works fine, but it doesn’t search well. )) Let’s say I’m looking for the word “work”, if it is in the table, then the data is displayed, but if there is no such word, but there is the word “work”, then it will not show it. (How can I make it look for similar words?
Answer 1, authority 100%
You need to use an additional morphological dictionary or a stemmer.
I usually use a stemmer for simple sites. The results are quite tolerable.
- Stemmer example: http://forum.dklab.ru/s/php-7 /advises-19/14279/
- Stemmer operation example: http://02.gibdd.ru/ search.htm?search=%F8%F2%F0%E0%F4