UPDATE `lcs_article_y` set `title`=replace(title,'要替换的字符','新字符'),`keywords`=replace(keywords,'要替换的字符','新字符')
sql语法: UPDATE 表名 SET 字段名=replace(字段名, ‘被替换字符串’, '用来替换的字符串') ; sql: UPDATE `member` SET `phone`=replace(`phone`, '\'', '') ;
UPDATE `lcs_article_y` set `title`=replace(title,'要替换的字符','新字符'),`keywords`=replace(keywords,'要替换的字符','新字符')
sql语法: UPDATE 表名 SET 字段名=replace(字段名, ‘被替换字符串’, '用来替换的字符串') ; sql: UPDATE `member` SET `phone`=replace(`phone`, '\'', '') ;