How to SELECT a column that contains a forward slash in the column name

181 views
Skip to first unread message

Attikus

unread,
Jul 2, 2008, 1:26:36 PM7/2/08
to The UDF Repository for MySQL
I am trying to SELECT the following column: Contact/End_User
How to I perform a SELECT stmt on it w/ the forward slash?
I get the following error:

mysql> SELECT Contact/End_User FROM Transactions;
ERROR 1054 (42S22): Unknown column 'Contact' in 'field list'
mysql>

Any help will be great

Thanks,
Attikus

Roland Bouman

unread,
Jul 7, 2008, 3:00:23 AM7/7/08
to The UDF Repository for MySQL
Attikus,

this is the wrong place to ask this kind of question. This group is
all about MySQL user-defined functions - not basic syntax questions.

Please go to the mysql forums next time. For now, read up on quoted
identifiers in the MySQL manual:

http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
Reply all
Reply to author
Forward
0 new messages