I am about to build a little search engine and I was wondering if experienced people could give me some advice. I was wondering which angle I should have:
RLIKE sounds good because of the use of RegExp. But LIKE or RLIKE have both the downside of being a pain when it comes to perform a search against multiple columns. My main problem with FULLTEXT is that it doesn't allow searches for words less than three chars. Hum... what about poor accrs and abbrs? Is there a trick I don't know? Like using wildcards maybe?
thanks for your time and patience