Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.3333
(333)333-3333
333-333-3333
3333333333
So I am wanting to find matches and ignore any non-numeric values and
need some help with the expression.
The query would be something like:
SELECT tel FROM leads WHERE do_not_call = '1' AND tel REGEXP 'the expression'
The number I am looking for will already have all the non numerics stripped and
will
be in the format of nnnnnnnnnn.
Any help would be appreciated.
Thank you,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
