From: Thimble Smith
Date: March 20 1999 8:31pm
Subject: Re: MySql - feature missing?
List-Archive: http://lists.mysql.com/mysql/700
Message-Id: <19990320133148.O17225@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

The MySQL manual gives you the answer:

SELECT expression AS alias ...

Tim