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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org