Need to remove numeric data from row in MySQL [duplicate]

Question

I have millions of data in MySQL table, now I need to update one particular column of the table with only non-numeric characters. That is I need to remove all numbers from that column. The row wont be deleted, only updated with only non-numeric values.

I need some efficient way to achieve this.

Calling 10 times replace doesn't look good.

Thanks, Ashish

It would help if you posted the create table for the incriminated table. — bpgergo
– bpgergo, Commented Jul 8, 2013 at 8:43
Need more information - are the numbers same, do the columns have a mix of numeric and non numeric values? Some sample of the data would help. — unlimit
– unlimit, Commented Jul 8, 2013 at 8:44
Possible dublicate: stackoverflow.com/questions/11431831/… — Maxim Zhukov
– Maxim Zhukov, Commented Jul 8, 2013 at 8:47

Kzqai · Accepted Answer · 2014-03-13 15:23:44Z

-1

For mysql, you just have to replace everything:

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

edited Mar 13, 2014 at 15:23

Kzqai

23.2k27 gold badges112 silver badges138 bronze badges

answered Jul 8, 2013 at 9:08

SATSANGI

291 gold badge2 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to remove numeric data from row in MySQL [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related