dynamic alias?

[Eric Bloomquist]

Hi all,

I'm wondering if it's possible to have a dynamic alias in MySQL.  The
result I'm looking for is essentially:

+-----------------+---------------------------+--------------------+
| Provider Name   | Facility Name             | Appts on 8/28/2010 | <==
+-----------------+---------------------------+--------------------+
| Mildred Ratched | Oregon State Hospital     |                 12 |
| Henry Jekyll    | London Internal Medicine  |                  3 | 
| ...             |                           |                    |

Where "Appts on 8/28/2010" instead includes whatever tomorrow's date is
when the query is run.

Is it possible to do something like this in a MySQL query?

Thanks,
Eric