mysql mariadb 正则替换 regexp_replace

需求sqlset @title = '[闲聊灌水]现在程序员的工资多少了？';set @want = '现在程序员的工资多少了？';-- mysqlupdate threads set title = regexp_replace(title,'^[:space:]{0,}\\[.{4}\\][:space:]{0,}','')where site='csdn';-- mariadbupdate

用户昵称不能为空

726人浏览 · 2022-03-20 13:08:40

用户昵称不能为空 · 2022-03-20 13:08:40 发布

需求

sql


set @title = '[闲聊灌水]现在程序员的工资多少了？';
set @want = '现在程序员的工资多少了？';
-- mysql
update threads set title = regexp_replace(title,'^[:space:]{0,}\\[.{4}\\][:space:]{0,}','')  where site='csdn';


-- mariadb
update threads set title = regexp_replace(title,'(\s)?\\[[^\\]]{4}\\]\s?','') where site = 'csdn';