title: One column, two names, mysql
body: <p>I am trying to standardize column naming in my mysql database. During the transition, I need to be able to access a column of a given table using both the new and the old column names.
  Specifically, these two queries need to return the same results.</p>
  
  <pre><code>SELECT `old` FROM `table`;
  SELECT `new` FROM `table`;
  </code></pre>
  
  <p>Also, any new data inserted into the new column name should be available through the old column name; and viceversa.</p>