Can't update int type column in mysql

Question

What is wrong with this mysql query?

UPDATE answers SET 23 = 2 WHERE user_id ='1';

I am trying to update an int(2) field, and this just isn't working.

23 is the name of the column by the way

Answer 1

If 23 is your column name then escape it using `

UPDATE answers 
SET `23` = 2 
WHERE user_id ='1';