title: MySQL MyISAM indexing a text column
body: <p>I have a slow performing query on my table. It has a where clause such as:</p>
  
  <pre><code>where supplier= 'Microsoft'
  </code></pre>
  
  <p>The column type is <em>text</em>. In phpmyadmin I looked to see if I could add an index to the table but the option is disabled. Does this mean that you can not index a text column? Does this mean that every update query like this is performing a full table scan?</p>
  
  <p>Would then the best thing to do is separate the column into it's own table and place an ID in the current table then place an index on that? Would this potentially speed up the query?</p>