MySQL problem: field named 'check' causing problem

[doc_z]

A PHP script which run without any problem for a long time is causing a problem. I found out that the error is caused by a field name in the MySQL data base which is named 'check'. To solve this problem I tried to rename this field with "ALTER TABLE ABC CHANGE check ..." but it doesn't work (due to the field name 'check').

How can I rename a field which is named 'check' or are there other ways to fix the problem?

It seems that my provider changed the MySQL version which leads to this problem.

[coopster]

Try prefixing the column name with the table name:
"ALTER TABLE ABC CHANGE ABC.check ..."

[doc_z]

It works.

Thanks.