regex - remove all numeric characters from column mysql

Question

I want to develop one mysql function that can remove only numeric characters from the string.

Answer 1

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','')