There is a database, weight ~10 gb, number of rows 45 million (they are divided into tables).
There are 10 columns, we need to search for 1 column which type is varchar.
Fulltext index in MySQL is not quite suitable, because the search goes after *. And need to search for words that have “ppl” as an example of the word apple.
Sphinx also as I read looking for thus (after *), therefore also does not approach.
Can you tell me what is better to use in this case?
Would a NoSQL solution work for me? (for example Cassandra, does she know how to search inside for words? In SQL query LIKE %text%)
Thanks