Re: Full-text searches sucks?

"Ryan A" <ryan@coinpass.com> writes: > Hey, > > > > I dont want to do that as its only mysql 4.1+ compatable, > > > > IN BOOLEAN MODE was added in version 4.0.1 not 4.1, for what it's > > worth. > > Oops, thats what i meant. The problem is a LOT of hosts are still on 3.23.xx > so I dont want to do the BOOLEAN MODE thing. Here is the workaround that I used. - If the search term is smaller than 3 words, I did a LIKE. - If the search term is greater than 3 words, do a fulltext search i.e. MATCH AGAINST (no BOOLEAN MODE) - If the fulltext search did not find any results, do the search again, but this time use LIKE instead of MATCH AGAINST. This gave me good enough results. -- Raj Shekhar Y! : Operations Engineer MySQL DBA, programmer and slacker Y!IM : lunatech3007 home : http://rajshekhar.net blog : http://rajshekhar.net/blog/