[Rails] Searching large tables with Rails?

[softwareengineer 99]

I have a large table (> 20,000 records)  with text columns for  which I need to build a search function. Is there a "Rails" way to  index all the entries and NOT search using LIKE?
  
  "LIKE" searches  can get very slow and I would rather build an index of the columns to speed up things.
  
  Just want to know if there is something like "acts_as_indexable"  available in ROR? Or even a way to quickly create a keyword index?
  
  I appreciate your assistance very much.
  
  Thanks
  Frank
  
		
---------------------------------
Relax. Yahoo! Mail virus scanning helps detect nasty viruses!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060206/aef59d7f/attachment.html