SELECT REPLACE (hmMAC,":","") as  from hostMAC WHERE;

#去掉00:0c:29:fe:1f:a5的冒号为000c29fe1fa5

#update 表名 set 列名 = REPLACE (mcategory,"要去掉的字符","") where 列名 like "%要去掉的字符%" 

#SELECT q.testid,q.docHtml FROM t_question q WHERE q.docHtml LIKE '%src=\\\\"/%'