using MATCH AGAINST - can you build for misspellings/partial matches?
Posted 23 August 2006 - 09:49 PM
Posted 24 August 2006 - 12:41 PM
SELECT * FROM WHERE MATCH(col) AGAINST('"string*"' IN BOOLEAN MODE);http://dev.mysql.com...xt-boolean.html
To match misspellings you could use (if available) the pspell functions to check and find correct spellings of possibly misspelled words. You could then replace the words in the search with the correctly spelled ones. Although, it may be better to give the user the option of putting the correctly spelled word in their search as a word may only seem to be misspelled when it's not. Similar to what google does.
If you can't use pspell functions, then you could possibly make your own function to find misspelled words using the soundex function. You'd create a custom dictionary with words and their soundkey and if the word entered doesn't exist in the standard dictionary you'd test against the soundkey dictionary to find possible mispellings. You'll have to test how effective this is.
MYSQL also has a SOUNDEX function but I don't see how it would help in this situation.
Posted 25 August 2006 - 03:32 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users