Basically I have a table called 'Telephone' with over 100,000+ records.

In this database I have numbers such as:-

90123456789

91234567893

97126372319

Basically I want to Update the Telephone.DB and SET the numbers so it strips the first number only if it starts with the number '9', so the result would end up as follows:-

0123456789

1234567893

7126372319

Any idea how I can achieve this using MySQL?