Column names that contain %

2002-05-31 Thread David Adam
I have a table that includes numerous column names of the form '%_Dry_Weight' -- that is, they start with a percent sign. I am unable to query these columns, as mysql returns a you have an error in your SQL syntax' message. When I try to escape the % character with a backslash, the error

Re: Column names that contain %

2002-05-31 Thread Dan Nelson
In the last episode (May 31), David Adam said: I have a table that includes numerous column names of the form '%_Dry_Weight' -- that is, they start with a percent sign. I am unable to query these columns, as mysql returns a you have an error in your SQL syntax' message. When I try to