List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:August 27 2010 4:56pm
Subject:Re: dynamic alias?
View as plain text  
  On 8/27/2010 11:16 AM, Eric Bloomquist wrote:
> Hi all,
>
> I'm wondering if it's possible to have a dynamic alias in MySQL.  The
> result I'm looking for is essentially:
See the manual page for PREPARE.

PB

-----
> +-----------------+---------------------------+--------------------+
> | 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