title: Dynamical alias from date in MySQL
body: <p>i would like to make dynamic alias from dates as you can se below. Everyday will be the name of column different. I tried it with variable but it doesn't work. The solution should be something like below or if i dont need to use variables it can be possible too.</p>
  
  <pre><code>SET @today = CURRENT_DATE(),
      @lastWeek = DATE_ADD(CURRENT_DATE(),INTERVAL -7 DAY);
  
  SELECT date1 AS @today, date2 AS @lastweek FROM table1;
  </code></pre>
  
  <p>Thank you for your help</p>