Everyone agrees that MySQL alone isn’t a great solution for text searching. Whenever the need arises, I’ve always recommended jumping ship to sphinx. And sphinx is great – it works, it’s highly customizable, and it’s free. But it doesn’t really come for free, it has overhead. You have to manage your indexer cron j... more »