title: Filtering based on a text column
body: <p>Is doing an exact match filter based on a text column conceptually slower than grabbing a set of rows based on a key and filtering using the programming language?</p>
  
  <p>For example:</p>
  
  <pre><code>select columns from table where textcolumn='exactphrase';
  </code></pre>
  
  <p>vs</p>
  
  <pre><code>select columns from table where key='key';
  
  for (results : resultset) { 
        if (resulsts.getString(textcolumn).equals(exactphrase)) { ... } }
  </code></pre>
  
  <p>I'm basically curious as to how MySQL (Innodb) deals with filtering text columns and what the performance pitfalls may be (if any).</p>