MySQL 按条件批量替换语句
Sonder
2022-08-08
169字
浏览 (2k)
mysql按条件批量替换语句。
将 article
文章表 content
字段里面的啊
替换成呀
,并且条件是look = 200
和 cid = 99
UPDATE article SET
content = replace(content, '啊', '呀')
WHERE look = 200 AND cid = 99;
mysql按条件批量替换语句。
将 article
文章表 content
字段里面的啊
替换成呀
,并且条件是look = 200
和 cid = 99
UPDATE article SET
content = replace(content, '啊', '呀')
WHERE look = 200 AND cid = 99;