MySQL statemant

This is my 1st use of the micronet so please let me know if my question
is out of bounds.

What's wrong with this statement?

UPDATE tablename SET columnname="newdata" WHERE columnname="olddata";

The column name I want to update is "E-mail" and the error message given is:

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '-mail="haveman_at_berkeley.edu" where
E-mail="hah15_at_columbia.edu"' at line 1

I'd swear that the syntax is correct as per several online instructions
and the MySQL online manual.
I suspect that it is the name of the column that is causing this error.
Any clues anyone?

-- 
Aaron DuBois
Sociology Tech
489 Barrows Hall
Mon-Fri 8:30am-12:30pm
510-643-9389
Department IST Security Officer
Departmental Equipment Custodian
------------------------------------------------------------------------
The following was automatically added to this message by the list server:
To learn more about Micronet, including how to subscribe to
or unsubscribe from its mailing list and how to find out
about upcoming meetings, please visit the Micronet Web site:
http://micronet.berkeley.edu/
Messages you send to this mailing list are public and world-viewable,
and the list's archives can be browsed and searched on the Internet.
This means these messages can be viewed by (among others) your bosses,
prospective employers, and people who have known you in the past.