I have a small single keyword text field...
Should I use FULLTEXT on the field or LIKE? The reason I ask, is because, ideally I would like the RDBMS to handle synonyms and inflections (ie: runs, running, runner, etc).
I suppose LIKE would work, assuming someone entered 'run' as it could potentially match all above. However, what if someone typed 'runnings' and actually meant 'runner'.
Soundex support would also be neat...
I need ot build a fairly sophisticated keyword search for an application but I do not have the luxury of detailed profile TEXT fields, instead I have a few single keyword VARCHAR fields...
Whats says you?
FULLTEXT or LIKE?
Moderator: General Moderators
-
alex.barylski
- DevNet Evangelist
- Posts: 6267
- Joined: Tue Dec 21, 2004 5:00 pm
- Location: Winnipeg
Re: FULLTEXT or LIKE?
LIKE.PCSpectra wrote:I have a small single keyword text field...
Should I use FULLTEXT on the field or LIKE? The reason I ask, is because, ideally I would like the RDBMS to handle synonyms and inflections (ie: runs, running, runner, etc).
I suppose LIKE would work, assuming someone entered 'run' as it could potentially match all above. However, what if someone typed 'runnings' and actually meant 'runner'.
Soundex support would also be neat...
I need ot build a fairly sophisticated keyword search for an application but I do not have the luxury of detailed profile TEXT fields, instead I have a few single keyword VARCHAR fields...
Whats says you?
Re: FULLTEXT or LIKE?
Sphinx (if you can) - http://www.sphinxsearch.com/
Bear in mind that if you use LIKE with wildcards at both sides it can't use an index (= slow)
Bear in mind that if you use LIKE with wildcards at both sides it can't use an index (= slow)
Re: FULLTEXT or LIKE?
LIKE doesn't handle synonyms & similar words. FULLTEXT does.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
-
rollydudez
- Forum Newbie
- Posts: 1
- Joined: Wed Jun 17, 2009 10:31 pm
Re: FULLTEXT or LIKE?
YEAH i think there is no similaritypickle wrote:LIKE doesn't handle synonyms & similar words. FULLTEXT does.
________________
where