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
source
share