Hi, i want select similar rows accourding to row's title columun. Title columun has mostly have 5 or 6 six keywords. Which algorithm do you recommend ? Soundex Maybe ? P.S: Title columun has unicode chracters like Ç, Ö, Ş... ...
I have an application in which SoundEx algorithm is implemented. Now i want to test the functionality. Here is what i observe In my database i have 2 names Breaks and Brakes. Assume these are names of 2 employees of a company. Now i am searching for the name giving Break as search criteria and now this returns me the 2 results breaks an...
Is there any way to have MySQL order results by how close they 'sound' to a search term? I'm trying to order fields that contain user input of city names. Variations and misspellings exist, and I'd like to show the 'closest' matches at the top. I know soundex may not be the best algorithm for this, but if it (or another method) could b...