Remove 91 in customer telephone number from database table

Question

I am using Magento 1.9.0.1 . I have customer data for my site. Previously I was collecting 12 digit telephone/mobile number while registration i.e. 91xxxxxxxxxx

But because of some reason, from now, I will collect customer numbers only of 10 digits i.e. without 91

So I want to remove 91 from all customer's telephone number from database tables

I do not have any idea where customer telephone numbers are present in Magento database tables

Answer 1

The easiest way to do this is to knock up a quick script that iterates over all the records in the database and if the first two characters in the target column are 91 remove and update the record.

I was going to suggest a dirty SQL query but it wouldn't account for 91 being in the middle of the string.

You could also, do a NICER script that loads the customer collection and iterates, using the Magento models to handle the data replication to the right tables/columns