UNIX REGULAR EXPRESSIONS QUESTIONS

[ROBERT HENDLEY]

QUESTION?

I have a field in mysql that has phone numbers stored in it. The problem
is that the program that originally stored the phone numbers into this
field let any thing through i.e.. joe, 48-967--5678, 6-12345456ext50
etc. To the new application I am required to use the existing data. I
would like a querry that will remove all records that are not in the
form 9999999999 and if possible update all valid phone numbers that just
have "-" in them but the right amount of digits.

Any ideas
Thanks
Robert Hendley