hi use ` instead of ' may solve the problem.
regards benny ----- Original Message ----- From: "Zach" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 06, 2003 7:04 PM Subject: Select statement with a field name that is a number? I'm trying to use a select statement for a table that uses numbers for the field names. Here is the query I've been trying. Please help! SELECT * FROM table_name WHERE '18'=1; (18 is the field name, 1 obviously is the value I'm looking for.) Everytime I have tried a variation, I get the same result where MySQL keeps evaluating the WHERE statement like a mathematical equation. -Zach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]