select * from emp where `file#` = 1332; returns ERROR 1054: Unknown column 'file' in 'where clause'
-----Original Message----- From: Bernard Clement [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:19 PM To: Howell, Scott; Mysql (E-mail) Subject: Re: HELP! Select queries for tables that has fields with # characters Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution. Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: > I am trying to query a table that has field names with # characters in > them. For example a table emp_earn has a field called FILE# > > I need to do a query where FILE# = 1332, but anything I try errors out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
