title: Trying to understand "Can't find FULLTEXT index matching the column list" error
body: <p>As I'm trying to understand SQL by playing around with the code a bit, I have run into this situation. I run this code</p>
  
  <pre><code>SELECT * FROM jobs WHERE MATCH ( title, location, description ) AGAINST ( 'New York designer')
  </code></pre>
  
  <p>and I get the right row results. However, if I ask myself, "okay so what if I want just look at one column?" </p>
  
  <pre><code> SELECT * FROM  jobs WHERE  match(location) against ('designer')
  </code></pre>
  
  <p>I get the error "Can't find FULLTEXT index matching the column list". Why? I'm not sure what this error means. I just remove two words and commas.</p>
  
  <p>I alter the jobs table to use the <code>MyISAM</code> engine. Does that mean it's searchable or "<code>FULLTEXT</code>"? Since <code>InnoDB</code> isn't searchable, is that correct to say? </p>
  
  <p>But now, when isolated to searching to one column, it's a problem? </p>
  
  <p>Let me know if this makes sense, I will re-edit.</p>