Results 1 to 5 of 5
Thread: LIKE, RLIKE or FULLTEXT?
May 2, 2004, 06:24 #1
- Join Date
- Feb 2004
- 0 Post(s)
- 0 Thread(s)
LIKE, RLIKE or FULLTEXT?
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