title: Scenario of SELECT a text column in MySQL
body: <p>How does mysql <code>SELECT</code> FROM a table which has one or more <code>TEXT</code> column?</p>
  
  <p>Assume this Query:</p>
  
  <pre><code>SELECT content FROM posts WHERE id = 1
  </code></pre>
  
  <p>As far as I know, <code>TEXT</code> types store in disk and have a pointer in table. so how this query works in action?<br>
  Which scenario is okay?</p>
  
  <p><strong>1</strong> : MySQL loads all text related to this table, then starts to search in table. finds #1, and gets the content and returns row. ( pre loading all <code>TEXT</code> )</p>
  
  <p><strong>2</strong> : MySQL search in table, finds #1, load the specific <code>TEXT</code> related to current matched row from disk and returns row. ( something like lazy loading!! )</p>
  
  <p>Or maybe MySQL works another way!</p>
  
  <p>and how a very large table with <code>TEXT</code> column in it, can reduce <code>SELECT</code> and reading speeds?</p>