List:General Discussion« Previous MessageNext Message »
From:Eric Bloomquist Date:August 27 2010 4:16pm
Subject:dynamic alias?
View as plain text  
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

Thread
dynamic alias?Eric Bloomquist27 Aug
  • Re: dynamic alias?Peter Brawley27 Aug
    • RE: dynamic alias?Eric Bloomquist27 Aug
      • Re: dynamic alias?Michael Dykman27 Aug
  • RE: dynamic alias?Steven Staples27 Aug