|All requests||>||What is the best PHP auto correct spe...||>||Request new recommendation||>||Featured requests||>||No recommendations|
by saurabh claritus - 7 years ago (2015-02-04)
I have multiple Hindi songs in our site but at time of searching I did not get the right song due to spelling mismatch.
So I need a solution which can make search into my database with wrong spelling as well return the right song, for instance PHOOL is similar to POOL, FOOL, FUL.
So it must suggest all available records from database.
1. by Tariqul Islam - 7 years ago (2015-02-04) Reply
You can use following code to search:
SELECT * FROM table WHERE table.column LIKE SOUNDEX('search_value');
If its not helpful for you or need any further assistance then inform me.
It seems this package does exactly what you want. It can search your database for records but first it may auto-correct your search keywords using another class.