View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 09:34 AM
Dodger
 
Posts: n/a
Default Fulltext searches, synonyms, and alternate spellings...

I was wondering if there was any way to somehow modify a fulltext
search to be able to match on full synonyms and (perhaps more
importantly) alternative spellings.

For instance,

INSERT
INTO some_table (words_text)
VALUES ('He parked the automobile with its tyres against the kerb.')

SELECT *
FROM some_table
WHERE MATCH (words_text)
AGAINST ('car tires curb')

....won't match at all, when any English-speaking human can see it
should.

Hoping for any recommendations on how to deal with this,

--
Dodger

Reply With Quote