title: mysql full text search is empty
body: <p>I am using ruby on rails with a MySQL backend.  I have a table called notes and here is the migration I use to create it:</p>
  
  <pre><code>def self.up
    create_table(:notes, :options =&gt; 'ENGINE=MyISAM') do |t|
      t.string :title
      t.text :body
  
      t.timestamps
    end
  
    execute "alter table notes ADD FULLTEXT(title, body)"
  
  end
  </code></pre>
  
  <p>I want to do full text searches on the title and body fields.  The problem is that the full text searches always come back empty.  For example if I add this row into the database: <code>Title: test, Body: test</code>.  Then I run this query <code>SELECT * FROM notes WHERE MATCH(title, body) AGAINST('test')</code>.  It returns a nil set.  Can anybody tell me what I am doing wrong and how to get full text search working?</p>