title: MySQL: Select Concat of strings and Length of resulting Concat
body: <p>In my CREATE VIEW I would like to:</p>
  
  <pre><code>SELECT CONCAT( t.str1, t.str2 ) AS Title, CHAR_LENGTH( Title ) AS Length
  </code></pre>
  
  <p>but this ill produce error: </p>
  
  <blockquote>
    <p>Unknown column 'Title' in 'field list'.</p>
  </blockquote>
  
  <p>What is the correct way of doing this without having to Concat same strings twice?</p>