I added a column to an existing mysql table using:
ALTER TABLE tablename ADD columnname varchar(10) AFTER anothercolumnname;
The following should remove the column; use bacticks to escape the table name:
ALTER TABLE tablename DROP column `columnname?`;
But are you certain that you did not accidentally enter a question mark when you added the column?