escaping column name

[richie]

When I run this query:

delete from logout where collection-owner='[e-mail]' limit 1

I get the error:

Unknown column 'collection' in 'where clause'

This suggests to me that the minus sign in "collection-owner" is confusing mysql.

I then tried

delete from logout where collection-owner='[e-mail]' limit 1

The error this time was:

You have an error in your SQL syntax near '-owner='[e-mail]' limit 1' at line 1

The easiest solution would have been to rename the column, but other binary .exe programs are using it that I have no control over.

How can I get mysql to accept this column name?

[toplay]

You can't have a dash in a column name. Change your column name to use an underscore which is allowed. Example: collection_owner

🙂

EDIT:

If you know that a dash is allowed in MySQL column names (which I think it's not), you could try enclosing the column name in backtick marks. Example: collection-owner

.

[bretticus]

Try enveloping the column name in backticks collection-ownerso you can change the column name at least.

[richie]

Yes, the backtick idea worked.

Thanks for the help.