MySQL Forums
Forum List  »  Full-Text Search

natural language search - does it work?
Posted by: Andreas Siegmund
Date: July 14, 2008 05:56AM

Hello everybody,

i just tried fulltext search, but i miss two essential features:

- error tolerant search ('housse' AGAINST 'house')
- partial word search ('hou' AGAINST 'house')

I see partial word search works with Boolean Search, but only for the first part of the word, not something like "*se" or so..

Am I doing something wrong with the character set (utf8_unicode_ci) or could somebody please confirm this, that these features also natural language search are not yet implemented?

At this moment, I would actually prefer like %..% over full-text search, as it is more fault-tolerant. I see the only real advantage at this point is it's better performance, as it works with a special index, which should be way faster than like?

Options: ReplyQuote

Written By
natural language search - does it work?
July 14, 2008 05:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.