title: full-text mysql search in rails
body: <p>I'm trying to add a simple mysql full-text search to a small table &lt;2000 entries. </p>
  
  <p>Please don't tell me to install solr, or any other search gems. I've tried to run them and it seems to be one issue after another. I'll get around to it one day, but that day is not today. </p>
  
  <p>I need to add an add_index migration, but when I run</p>
  
  <pre>
  add_index :users, :name, :fulltext
  </pre>
  
  <p>I get an error. - undefinded method 'key'. </p>
  
  <p>I can't seem to find any documentation anywhere which explains how to make a fulltext mysql search in rails.</p>
  
  <p>What is the correct statement I'm supposed to use for the add_index, and once that is done, do I have to anything special in my model to use the fulltext search?</p>