MySQL - SQL programming

[WrathOfAchilles]

Good morning all.

Looking at tidying up a telephone_no field, removing any chars that are not numbers (i.e any (), spaces, letters etc) The field is varchar.

I have been looking at various string functions, just woundered if anyone had any code snippets i might find useful?

Kind regards,

Martin

 

[WrathOfAchilles]

Hmm, was hoping to use SQL rather than PHP.

Cheers tho,

Marty