Question

MYSQL怎么替换字符串

我文章的标题中有很多“生活小常识——”想把这几个字从数据库中批量删除怎么删

表 : pb_tudouthreads 字段 subject

万分感谢
1楼朋友 照你的方法怎么把整行都删除了 我只要删除“生活小常识——”这几个字就可以了

Answer 1

你数据的具体情况我不是很清楚，这两种语句你自己看着用吧
select stuff(subject,1,7,'') as subject from pb_tudouthreads
--stuff(列名，从第几个字符开始，长度，替换成什么)

UPDATE pb_tudouthreads
SET subject= REPLACE(subject, LEFT(subject, 7), '')
WHERE (subject NOT LIKE '生活小常识——”%')

Answer 2

update pb_tudouthreads
set subject= replace(subject,'生活小常识--','')
where subject like '%生活小常识--%';