mysql替换指定字符

UPDATE hospital SET NAME = REPLACE ( NAME , '*', '' );