title: Incremental table names
body: <p>I'm currently trying to find some information with a query that will automatically update on a website every 24 hours - this involves a number of columns in a daily backup table that I need to pull information from.</p>
  
  <p>The problem I have is the query has to specifically state the database table, which makes the query rather static - and I need something a bit more dynamic.</p>
  
  <p>I have a daily backup table with the naming system as follows:</p>
  
  <pre><code>daily_backup_130328 
  daily_backup_130329 
  daily_backup_130330 
  daily_backup_130331 
  daily_backup_130401 
  daily_backup_130402
  </code></pre>
  
  <p>So when I state my FROM table, I name one of these - usually the latest one available (so <code>"daily_backup_0402"</code> from the example list). Currently the only way I can get this to update is to manually go in and update the query every day before the scheduled run.</p>
  
  <p>My question is: is there a way that I can get it to select the latest "daily_backup_??????" table automatically?</p>
  
  <p>Edit: I'm on about bog standard queries like "SELECT * FROM daily_backup_130402" ORDER BY CheeseType ASC;</p>