Thanks, PREPARE certainly has some potential. Unfortunately, when I try to use that sort of thing inside of a Cognos report, it complains that "At least one expression in the Select clause is missing the AS clause to make it a proper alias."
(Sorry I didn't include the Cognos context -- it didn't occur to me that it'd be relevant.) Thanks, Eric -----Original Message----- From: Peter Brawley [mailto:peter.braw...@earthlink.net] Sent: Friday, August 27, 2010 12:57 PM To: mysql@lists.mysql.com Subject: Re: dynamic alias? 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=eric_bloomqu...@cooley-dickinson.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
