you were so close http://www.mysql.com/doc/en/SELECT.html
SELECT COLUMNNAME AS WHATEVER FROM TABLENAME; Marty Gainty ----- Original Message ----- From: "Ian O'Rourke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 19, 2004 2:16 PM Subject: Expressions > Regarding the following query: > > SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m > %y'),SectionID,Title,Summary,Content FROM articles > ORDER BY EntryDate > DESC LIMIT 10 > > Okay, I've looked in the manually up and down, as I know how to do it in > Access, but I can't find it. I want to set an expression so I can give the > Date_Format function a handy name - so it returns the name of the column as > ArticleDate, for instance. > > I'm missing something simple :) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]