0

Am stuck at a little problem. I have a MySQL database with 4 columns. I have a customer_name column which assumes all the text in it should me customers name. But someone some customer names mix up with some numerical text and some unreadable characters. So can you suggest me the easy way to format the column by replacing the numerical text and undesirable characters.

Eg:

Current Column:

User123 user12user 123usernew A$ءنشناuserold

Expected Output:

User useruser usernew userold

I hope you guys got what am trying to say, any help is appreciated. The column is of nearly 1000K Values in it. so importing or recreating is a bit risk for me.

Arun Green
  • 23
  • 1
  • 1
  • 7
  • Do you need to just batch process your current table, or establish a routine for sanitizing customer names down the road? – Jeremy Carlson Nov 25 '14 at 04:02
  • This may help you [How to display UTF-8 characters in phpMyAdmin](http://stackoverflow.com/questions/4777900/how-to-display-utf-8-characters-in-phpmyadmin) – Rafiqul Islam Nov 25 '14 at 04:16
  • @JeremyCarlson, Both. I want to process the current table and also add a new routine for filling column with name only and no undesirable characters in future. – Arun Green Nov 25 '14 at 04:27
  • @Rafiq thanks for the garbage text cleaning solution. – Arun Green Nov 25 '14 at 04:29

0 Answers0