CODEWITHSUNDEEP
mysqlfull-text-searchsoundex
Jay
Jay

Reputation: 782

MySQL query to do FULL TEXT INDEXING and similar sound words

I have a table as shown below. A user can search this table on the basis of Interests. For example, user can search “Carl to”. Then it should return the first 2 emails, because we have 2 similar sounding words like Carl, Karl and to, two. At the same time, the search is based on multiple words and not just a single word. Hence it has to be FULL TEXT INDEXING.

But I don’t know how this will be possible. How can I make a query that satisfies both FULL TEXT INDEX and similar sound words?

Any help in this regard is highly appreciated.

Id  |   email           |   Interests
-------------------------------------------
1   | [email protected]     | travel to Carl
2   | [email protected]     | journey two Karl
3   | [email protected]   | float in the ocean

Upvotes: 0

Views: 117

Answers (0)

Related Questions