Fuzzy address matching using mysql match (if possible using weights for better ranking of results)

I have myISAM table with index FULLTEXTtrying to do

SELECT 
    lk.id,
    lk.address
FROM 
    lk 
WHERE MATCH 
    lk.address 
AGAINST('235 regent street, london w1b 2et');

I get results, but only those who received the word "London" inside, or those who received the word "street" inside. I know that 3 ft_min_word_lencharacter words are not indexed, so "235", "w1b", "2et" are ignored, but what about "regent"? What is the STANDARD way to do this? fuzzy address mapping. thank

+3
source share
1 answer

The answer is to use MATCH AGAINST('...' IN BOOLEAN MODE)and add +before each word.

, : http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html

, .

+1

All Articles