MYSQL替换语句

 

update   `dede_art` set title=replace(title,' <IMG border=0 src=Images/hot.gif>','');

update '表名(比如我案例中的dede_art)' set 要修改字段名 = replace (要修改字段名,'被替换的特定字符','替换成的字符')

SELECT * FROM `supe_spaceitems` where `subject` like '%狐狸天空%'

update `supe_spaceitems` set subject=replace(subject,' - 狐狸天空――专业的两性健康资讯站','');