mysql full text search

Question

MySQL

Is it possible to do a mysql search without an exact word match?

Example:
1. I have a record in the database with the word Mixer s
2. The user enters the word mixer a in the search
3. With the help of the steamer, I cut mixer a to mixer
4. I do a full-text search for the word mixer , naturally the record with the word Mixer s is not there is.

ps The problem is solved with the help of a selection through like, but since the table has 100 records, it takes 3 seconds, which is not very satisfactory.

Answer 1

You can use sphinx

Answer 2

Take a ready-made solution or develop it yourself - you need a table with indexes

Answer 3

you can try to raise apache lucene and run something like soundex.

Answer 4

You need a full-text search engine that can index text based on morphology. Such as Yandex.Server company.yandex.ru/technology/server/
There are alternatives, for example risearch.org/
Let me explain: like, in the general case, it does a full table scan, which is slow. And for a quick full-text search, you need an index, which the above tools build.