一下任何一句都可以
其实你原先的帖子已经有答案了update tbl_name set field_name=if(field_name REGEXP '/$', substr(field_name,1,length(field_name)-1),field_name)
update tbl_name set field_name=if(field_name RLIKE '/', substr(field_name,1,length(field_name)-1),field_name)
update tbl_name set field_name=substr(field_name,1,length(field_name)-1) where field_name REGEXP '/$'
update tbl_name set field_name=substr(field_name,1,length(field_name)-1) where field_name RLIKE '/''
update tbl_name set field_name=left(field_name,length(field_name)-1) where field_name REGEXP '/$'
update tbl_name set field_name=left(field_name,length(field_name)-1) where field_name RLIKE '/''
其实你原先的帖子已经有答案了update tbl_name set field_name=if(field_name REGEXP '/$', substr(field_name,1,length(field_name)-1),field_name)
update tbl_name set field_name=if(field_name RLIKE '/', substr(field_name,1,length(field_name)-1),field_name)
update tbl_name set field_name=substr(field_name,1,length(field_name)-1) where field_name REGEXP '/$'
update tbl_name set field_name=substr(field_name,1,length(field_name)-1) where field_name RLIKE '/''
update tbl_name set field_name=left(field_name,length(field_name)-1) where field_name REGEXP '/$'
update tbl_name set field_name=left(field_name,length(field_name)-1) where field_name RLIKE '/''
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货