Hi, On Jan 18, 2008 2:59 PM, RoryGRen <[EMAIL PROTECTED]> wrote: > > Hi all > > I am quite new to mySQL and have the following question I hope someone can > help me with: > > I have a database table imported directly from MS Access with two of the > field names having brackets - F(1) and S(1). I don't want to change the > field names, as I am simply going to import again when the database needs > updating. > > How can I select these fields from the table? - SELECT F(1), S(1) doesn't > work, SELECT "F(1)" , "S(1)" doesn't work and neither does SELECT [F(1)], > [S(1)]
Quote the names with backticks: `F(1)`, `S(1)` -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
