title: MySQL fulltext index
body: <p>I'm trying to set up a FULLTEXT index in an existing db table (with like 50k records), with the command below, which worked:</p>
  
  <pre><code>ALTER TABLE  `record_attributes` ADD FULLTEXT  `FULLTEXT` (`content_text` ,`content_varchar`)
  </code></pre>
  
  <p>Problem is, when I try to do a MATCH AGAINST on that table, it gives me this error:</p>
  
  <pre><code>#1191 - Can't find FULLTEXT index matching the column list
  </code></pre>
  
  <p>I've been searching on google and didn't find anything that I could be doing wrong. Does the index have to be added on tables without any records?</p>
  
  <p>Cheers</p>