FULLTEXT or LIKE?
Posted: Fri May 22, 2009 3:39 pm
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?
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?