mysql 语句，高手给看看

send

UPDATE `article` SET `title` = replace(`title`， '学院', ' ')
WHERE `title` LIKE'%学院%'

替换所有标题里含有学院的关键字  

这语句不对吗

Zeraba

title后面的逗号用英文状态的半角逗号 ,  其他参考2楼

send

means 发表于 2016-6-27 03:35
UPDATE `article` SET `title` = replace(`title`， '学院', ' ');

LIKE %不建议随便用

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 '， '学院', ' ')' at line 1

means

UPDATE `article` SET `title` = replace(`title`， '学院', ' ');

LIKE %不建议随便用