UNIX REGULAR EXPRESSIONS QUESTIONS

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: ROBERT HENDLEY
Date:  
Subject: UNIX REGULAR EXPRESSIONS QUESTIONS
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