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 escape the % character with a backslash, the
> error persists. If I put the column name in single quotes (e.g., select
> '%_Dry_Weight' from xxx) , the syntax is accepted, but the query returns
> the column name, rather than the values stored. According to the manual
> for 3.23.41 (which I am using), all characters are acceptable in column
> names. I am at an impasse - can anyone steer me in the proper
> direction? Many thanks!
backtics: `%_Dry_Weight`
Or use a column name like Pct_Dry_Weight :)
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
