Columns named with the # character

["Erling Paulsen" <erlingp@xxxxxxxxxxxxxx>]

I just exported (via myodbc) an old access database for my sportsclub to
mysql (the tables). The ms-access database application still works nicely on
the new linked tables in mysql. However, I'm now also writing a php based
client to use the database over the web and the problem is as follows:

They guy that developed the access database used `#' (comment character)
characters to name certain columns. i.e. "Person#". How can manually select
such a column in a mysql query (ex. via the mysql client)?  - since it seems
whatever i enclose the column name in, the rest of the query is interpreted
as a comment!

--
Erling Paulsen
Norway



---------------------------------------------------------------------
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 <mysql-thread68405@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php