Thank you much. I don't know why that didn't occur to me. :) Edward Dudlik Becoming Digital www.becomingdigital.com
----- Original Message ----- From: "Jim Winstead" <[EMAIL PROTECTED]> To: "Becoming Digital" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, 09 June, 2003 22:18 Subject: Re: Trouble with SELECT AS syntax On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > SELECT item_name AS name, item_desc AS desc FROM food; 'desc' is a reserved word. Try: SELECT item_name AS name, item_desc AS `desc` FROM food; Jim Winstead MySQL AB -- 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]