且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从mysql列中删除所有数字字符

更新时间:2023-02-09 21:07:51

定义的函数,其中可以写你的替换逻辑,也可以尝试:

You can write a user defined function, where in you can write your logic of replacement or you can try :

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(column,'9',''),'8',''),'7',''),'6',''),'5',''),'4',''),'3',''),'2',''),'1',''),'0','')