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