MySql statement needed

[cd34]

create tablenamebackup select * from tablename;
update tablename set fieldname=replace(fieldname,'!','');

tablenamebackup = whatever you want that signifies that you made a backup
tablename = the table that contains the data you want to change
fieldname = the name of the field that has the data you want to change

if you don't know the name of the table or how the table is laid out:

show tables;
describe tablename;

If you're using phpmyadmin, you should be able to navigate through and get the info from the command above.

note, if you screw up:

delete from tablename;
insert into tablename select * from tablenamebackup;